Python-讀取excel(python read excel using pandas)
簡單記錄一下讀取excel
import pandas as pd
xls_file = pd.ExcelFile('AAA.xlsx')
df = xls_file.parse('工作表1')
print(df)
print(df.columns)
import pandas as pd
xls_file = pd.ExcelFile('AAA.xlsx')
df = xls_file.parse('工作表1')
print(df)
print(df.columns)
留言
張貼留言