# left에 존재하는 Key가 있는 데이터만 merge
df_merge_how_left = pd.merge(df_left, df_right, how='left', on='KEY') 

# right에 존재하는 Key가 있는 데이터만 merge
df_merge_how_right = pd.merge(df_left, df_right, how='right',  on='KEY') 

# left 및 right 양쪽에 존재하는 Key가 있는 데이터만 merge
df_merge_how_inner = pd.merge(df_left, df_right, how='inner', on='KEY') 

# 양쪽에 존재하는 모든 Key기준 merge
df_merge_how_outer = pd.merge(df_left, df_right, how='outer', on='KEY') 

# 각 데이터가 left, right 또는 양쪽의 출처인지 표시(_merge란 컬럼에 표시)
pd.merge(df_left, df_right, how='outer', on='KEY', indicator=True) 

#양쪽의 컬럼명이 중복될때 _left나 _right를 컬럼명에 추가함
pd.merge(df_left_2, df_right_2, how='inner', on='KEY', suffixes=('_left', '_right')) 

Installing a root/CA Certificate

Given a CA certificate file foo.crt, follow these steps to install it on Ubuntu:

1. Create a directory for extra CA certificates in /usr/share/ca-certificates:

   sudo mkdir /usr/share/ca-certificates/extra

2. Copy the CA .crt file to this directory:

   sudo cp foo.crt /usr/share/ca-certificates/extra/foo.crt

3. Let Ubuntu add the .crt file's path relative to /usr/share/ca-certificates to /etc/ca-certificates.conf:

   sudo dpkg-reconfigure ca-certificates

   To do this non-interactively, run:

   sudo update-ca-certificates

In case of a .pem file on Ubuntu, it must first be converted to a .crt file:

openssl x509 -in foo.pem -inform PEM -out foo.crt

1. Download the 3 required dependencies from Launchpad (not providing direct links so you can check it's legit):

a. https://launchpad.net/ubuntu/bionic/amd64/libicu60/60.2-3ubuntu3 (libicu60_60.2-3ubuntu3_amd64.deb (7.7 MiB))

b. https://launchpad.net/ubuntu/bionic/amd64/libjavascriptcoregtk-1.0-0/2.4.11-3ubuntu3

(libjavascriptcoregtk-1.0-0_2.4.11-3ubuntu3_amd64.deb (1.8 MiB))

c. https://launchpad.net/ubuntu/cosmic/amd64/libwebkitgtk-1.0-0/2.4.11-3ubuntu3

(libwebkitgtk-1.0-0_2.4.11-3ubuntu3_amd64.deb (7.7 MiB))

2. Install the files in that order in the terminal

(assuming the files are in the Downloads folder)

cd ~/Downloads sudo dpkg -i libicu60_60.2-3ubuntu3_amd64.deb sudo dpkg -i libjavascriptcoregtk-1.0-0_2.4.11-3ubuntu3_amd64.deb sudo dpkg -i libwebkitgtk-1.0-0_2.4.11-3ubuntu3_amd64.deb sudo dpkg -i icaclient_19.3.0.5_amd64.deb

This correctly installs Citrix Workspace. If you then get connection errors when trying to set it up, also implement step 3.

3. Fix the certificate error.

sudo ln -s /usr/share/ca-certificates/mozilla/* /opt/Citrix/ICAClient/keystore/cacerts/ sudo c_rehash /opt/Citrix/ICAClient/keystore/cacerts/

$ git clone https://github.com/black7375/BlaCk-Void-Zsh.git ~/.zsh

$ bash ~/.zsh/BlaCk-Void-Zsh.sh

Powerline Font  설정

$ sudo apt-get install fonts-powerline

or

# clone
$ git clone https://github.com/powerline/fonts.git --depth=1

# install

$ cd fonts

$ ./install.sh

# clean-up a bit

$ cd ..

$ rm -rf fonts

[출처] 멋진 ZSH 설정!! (네이버 리눅스 유저 그룹) |작성자 BlaCk7375

요즘 emacs나 vi에디터를 많이 쓰면서 control키를 새끼 손가락으로 누르는 일이 많아졌다.

보통의 키보드에는 control키가 왼쪽 아래 존재하다 보니 새끼 손가락이 많이 무리가 간다.

옛날의 unix키보드처럼 배열을 바꿔서 사용해보려고 한다.

# 먼저 아래 파일을 Editor로 연다.
$ sudo vi /etc/default/keyboard

# XKBOPTIONS을 찾아 ctrl:nocaps를 써서 Caps Lock키를 추가적으로 Control키로 사용하도록 한다.
# 또는 ctrl:swapcaps를 써서 Caps Lock키와 Control키의 기능을 바꾼다.

XKBOPTIONS="ctrl:nocaps"

# 다음으로 변경된 내용이 반영되도록 아래 명령어를 실행한다.
$sudo dpkg-reconfigure keyboard-configuration

./configure --with-features=huge --enable-cscope --enable-multibyte --enable-python3interp --with-python3-config-dir=/usr/lib/python3.7/config-3.7m-x86_64-linux-gnu --enable-fail-if-missing
make
sudo make install

Fisa Vim Config (http://fisadev.github.io/fisa-vim-config/)

sudo apt-get install curl vim exuberant-ctags git ack-grep
sudo pip install pep8 flake8 pyflakes isort yapf

mv ~/.vimrc ~/.vimrc.org
wget -O ~/.vimrc  https://raw.github.com/fisadev/fisa-vim-config/master/.vimrc 

1. Neovim을 설치한다.

2. Nvim의 fisa-dev를 설정한다.

    http://nvim.fisadev.com/

3. coc-nvim (intellisense plugin)을 설치한다.

    가. Node.js설치       

curl -sL install-node.now.sh/lts | sudo bash

    나.  Yarn 설치

curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | sudo apt-key add -
echo "deb https://dl.yarnpkg.com/debian/ stable main" | sudo tee /etc/apt/sources.list.d/yarn.list
sudo apt-get update && sudo apt-get install yarn

   다. VIM Plugin설치    

curl -fLo ~/.local/share/nvim/site/autoload/plug.vim --create-dirs https://raw.githubusercontent.com/junegunn/vim-plug/master/plug.vim

   라. ~/.config/nvim/init.vim에 아래 내용 추가

call plug#begin('~/.config/nvim/plugged')
" Use release branch
Plug 'neoclide/coc.nvim', {'branch': 'release'}
" Or latest tag
Plug 'neoclide/coc.nvim', {'tag': '*', 'branch': 'release'}
" Or build from source code by use yarn: https://yarnpkg.com
Plug 'neoclide/coc.nvim', {'do': 'yarn install --frozen-lockfile'}
call plug#end()

   마. nvim실행후 coc 모듈 설치

        :CocInstall coc-json

        :CocInstall coc-python

        :CocInstall coc-pypl

   바.  ./config/nvim/coc-settings.json 파일에 Python language server설정 추가

{
  "languageserver": {
      "golang": {
            "command": "gopls",
            "rootPatterns": ["go.mod", ".vim/", ".git/", ".hg/"],
            "filetypes": ["go"]
          },
      "ccls": {
            "command": "ccls",
            "filetypes": ["c", "cpp", "objc", "objcpp"],
            "rootPatterns": [".ccls", "compile_commands.json", ".vim/", ".git/", ".hg/"],
            "initializationOptions": {
                     "cache": {
                                "directory": "/tmp/ccls"
                              }
                   }
           },
      "python": {
         "command": "python",
         "args": [
              "-mpyls",
              "-vv",
              "--log-file",
              "/tmp/lsp_python.log"
            ],
         "trace.server": "verbose",
         "filetypes": [
              "python"
            ],
         "settings": {
              "pyls": {
                     "enable": true,
                     "trace": {
                              "server": "verbose"
                            },
                     "commandPath": "",
                     "configurationSources": [
                              "pycodestyle"
                            ],
                     "plugins": {
                              "jedi_completion": {
                                         "enabled": true
                                       },
                              "jedi_hover": {
                                         "enabled": true
                                       },
                              "jedi_references": {
                                         "enabled": true
                                       },
                              "jedi_signature_help": {
                                         "enabled": true
                                       },
                              "jedi_symbols": {
                                         "enabled": true,
                                         "all_scopes": true
                                       },
                              "mccabe": {
                                         "enabled": true,
                                         "threshold": 15
                                       },
                              "preload": {
                                         "enabled": true
                                       },
                              "pycodestyle": {
                                         "enabled": true
                                       },
                              "pydocstyle": {
                                         "enabled": false,
                                         "match": "(?!test_).*\\.py",
                                         "matchDir": "[^\\.].*"
                                       },
                              "pyflakes": {
                                         "enabled": true
                                       },
                              "rope_completion": {
                                         "enabled": true
                                       },
                              "yapf": {
                                         "enabled": true
                                      }
                           }
                  }
           }
      }
    }
}

4. nvim default editor설정

sudo update-alternatives --install /usr/bin/vi vi /usr/bin/nvim 60
sudo update-alternatives --config vi 
sudo update-alternatives --install /usr/bin/vim vim /usr/bin/nvim 60 
sudo $ update-alternatives --config vim 
sudo update-alternatives --install /usr/bin/editor editor /usr/bin/nvim 60
sudo update-alternatives --config editor

1. Linux Outliner (Windows도 가능)

https://www.giuspen.com/cherrytree/#downl

1. Install wget and Cherrytree dependencies.

2.  

   sudo apt install wget python-dbus python-chardet python-enchant libcanberra-gtk-module libgtksourceview2.0-0 libgtksourceview2.0-common python-cairo python-gobject-2 python-gtk2 python-numpy

3. Download python-gtksourceview2.

   wget http://ftp.br.debian.org/debian/pool/main/p/pygtksourceview/python-gtksourceview2_2.10.1-3_amd64.deb

4. Install python-gtksourceview2.

   sudo dpkg -i python-gtksourceview2_2.10.1-3_amd64.deb

5. Download Cherrytree.

   wget http://www.giuspen.com/software/cherrytree_0.38.9-0_all.deb

6. Install Cherrytree.

   sudo dpkg -i cherrytree_0.38.9-0_all.deb

https://stackedit.io/app

https://www.tagspaces.org/

https://joplinapp.org/

2. Albert

맥의 알프레드와 같은 역할을 한다.

Ctrl + tab키로 단축키를 지정해놓으면 편리하다.

https://software.opensuse.org/download.html?project=home:manuelschneid3r&package=albert

3. 한글폰트 설정

나눔글꼴

$ sudo apt install fonts-nanum

나눔고딕 코딩체

$ sudo apt install fonts-nanum-coding

4. shutter (Capture 프로그램)

sudo add-apt-repository ppa:linuxuprising/shutter

sudo apt install shutter

sudo apt remove --auto-remove shutter

4. Hangul Input Method

https://nimf-i18n.gitlab.io/ko/installation/

sudo apt-add-repository ppa:hodong/nimf -y

sudo apt update

sudo apt-get install im-config zenity

sudo apt install nimf nimf-libhangul -y

im-config -n nimf

5. Notebook Battery Saving

sudo add-apt-repository ppa:linrunner/tlpsudo

apt-get updatesudo

apt-get install tlp tlp-rdw

(씽크패드 유저라면 아래 내용 추가)sudo apt-get install tp-smapi-dkms acpi-call-dkms

6. ZSH Theme설정

powerlevel10k

https://github.com/romkatv/powerlevel10k

7. XFCE Terminal Theme

https://www.maketecheasier.com/best-xfce-terminal-themes/

https://github.com/nthirtyone/mariana-scheme

8. emacs최신버전(28버전)설치

Repository를 추가 한다.

[28버전]

sudo add-apt-repository ppa:ubuntu-elisp/ppa 
sudo apt-get update 
sudo apt install emacs-snapshot

[25버전]

sudo add-apt-repository ppa:kelleyk/emacs 
sudo apt-get update 
sudo apt install emacs25

[26버전]

sudo add-apt-repository ppa:kelleyk/emacs 
sudo apt-get update 
sudo apt install emacs26

[기본 에디터 변경]

sudo update-alternatives --config emacs

user@user-desktop:~$ update-alternatives --config emacs
There are 2 choices for the alternative emacs (providing /usr/bin/emacs).

  Selection    Path                     Priority   Status
------------------------------------------------------------
  0            /usr/bin/emacs-snapshot   27        auto mode
* 1            /usr/bin/emacs-snapshot   27        manual mode
  2            /usr/bin/emacs24-x        27        manual mode

ssl 인증서(*.crt)파일을 준비한다.

# trust anchor localhost.crt

# trust extract-compat

/usr/lib/python3.7/site-packages/pacman_mirrors/functions/ 아래에

httpFn.py를 수정한다.

context = ssl._create_unverified_context()

response = urllib.request.urlopen(requests, data=data.encode('utf-8'), context=context)

참고 : https://www.slideshare.net/freepsw/boosting-bagging-vs-boosting