如何将顶行google工作表转换为索引数据框

Question

样本没有，标题=0

dfGetMoniter = pd.DataFrame(data=gc.open("Data").worksheet("Moniter").get_all_values())

for index, row in dfGetMoniter.iterrows():

    print(index)

发出

0
1
2
3

但我想像这样显示google工作表顶部的标题行

A
B
C
D

我试着把，header=0像pd.read_csv一样，得到了一个错误

dfGetMoniter = pd.DataFrame(data=gc.open("Data").worksheet("Moniter").get_all_values(),header=0)

for index, row in dfGetMoniter.iterrows():

    print(index)

E:\PycharmProjects\exsample\venv\Scripts\python.exe E:/PycharmProjects/exsample/BinanceTutorialVideo-master/now/sheetManager.py
Traceback (most recent call last):
  File "E:/PycharmProjects/exsample/BinanceTutorialVideo-master/now/sheetManager.py", line 16, in <module>
    dfGetMoniter = pd.DataFrame(data=gc.open("Data").worksheet("Moniter").get_all_values(),header=0)
TypeError: __init__() got an unexpected keyword argument 'header'

Process finished with exit code 1

编辑更改

for col in dfGetMoniter.columns:
    print(col)

不行

Answer 1

数据帧的列可从columns属性中获得：

dfGetMoniter.columns

Index(['A', 'B', 'C', 'D'], dtype='object')

for col in dfGetMoniter.columns:
    print(col)

A
B
C
D

看一下introductory tutorials