Python如何讀取excel檔(.xlsx)?如何用欄標籤提取某一直行?df=pandas.read_excel() ; df[“欄標籤”]

import pandas as pd
f3 = r”C:\Python\example\csvreader\skl_cashFlowIRR2.xlsx”
df3 = pd.read_excel(f3) ;
print( df3,”\n”,type(df3) ) #DataFrame
print( df3[“Cash Flow 1″],”\n”,type(df3[“Cash Flow 1”])) #Series
print( list(df3[“Cash Flow 1”]) )

#取得到這個list,

#就可以用numpy_financial.irr()計算內部報酬率

輸出: