import pandas as pd
1屠列、通過字典創(chuàng)建數(shù)據(jù)框DataFrame
import pandas as pd
df = pd.DataFrame({'key' : ['b','b','a','c','a','b','a'], 'data1' : range(7)})
2啦逆、pandas 讀取csv
import pandas as pd
one=pd.read_csv(r'/Users/dapeng/Documents/user_kmeans/Python_book/3Programing/One.csv',sep=",")
3、設(shè)置工作目錄
#設(shè)置工作目錄
import pandas as pd
import os
os.chdir(r'/Users/dapeng/Documents/user_kmeans/Python_book/3Programing')
one=pd.read_csv('One.csv')
4笛洛、pandas 讀取Excel
import pandas as pd
xls = pd.read_excel('hsb2.xlsx', sheet_name=0)
xls = pd.read_excel('hsb2.xlsx', sheet_name=‘hsb2’)
sheet_name：指定表格的第幾個sheet夏志，默認(rèn)第一個，可以傳遞整數(shù)苛让，也可以傳遞sheet的名稱沟蔑。
5、導(dǎo)出數(shù)據(jù)寫入csv
xls.to_csv('copyofhsb2.csv')
PS : 文中資料免費(fèi)獲取地址：https://www.yuque.com/buliangren-ggoez/ow7q27/kl28kc
