# 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