Excel freeze title row
去檢視頁(view tab) 點凍結窗格(Freeze Panes) 凍結頂端列(Freeze Top Row) Done! Good for Screensh…
Take multiple lists into a dataframe
pd.DataFrame({‘list1Title’: list1, ‘list2Title’: list2,’list3Title’: list3}) &nb…
Initialize one variable in python
variable = None
Check one cell in dataframe is nan or not
pd.isnull(df.iloc[1,0])
gitconfig
放在~/.gitconfig 我自己常用的: [color] ui = true [alias] br = branch ci = commit -v cia …
Move the legend of pandas plot
有時候legend字太多會擋到圖，這時可以用.legend(bbox_to_anchor=(1.5, 1)): pd.DataFrame(sample_arra…
How to access ubuntu bash files in windows
cd /mnt/c ls
Generating a new SSH key
ssh-keygen -t rsa -b 4096 -C “[email protected]” 檢視: cat .ssh/id_rsa.pub &n…
Dataframe to file
df.to_csv(file_name, index=False, encoding=’utf-8′) index=False要加，不然讀的時候會多一排inde…
SSL Certificate for Your Website
想寫這篇文章已經很久了，但是每次更新SSL Certificate時，有時候都要等個幾小時的驗證，就一直拖… 一年更新一次，我大概也拖了兩次了吧&#…