df.columns returns RangeIndex

user_12746530 0
Viewed 1977

When I print out the columns in my df like so

user_df=pd.DataFrame(user)
    print(user_df.columns)

the output is RangeIndex(start=0, stop=12, step=1), instead of the column names ['phone','unique phone numbers','group','County','PNC/ANC','Facility Name','Date of enrollmnet'].

What I am missing? How can I solve this?

pandas google-sheets dataframe python
1 Answers

As per my comment, looks like your data doesn't have headers assigned, so therefor returning RangeIndex. Try the following instead:

userlist_wb = gc.open_by_key('key').worksheet('masteruser')
user = userlist_wb.get_all_values()
headers = user.pop(0)
user_df = pd.DataFrame(user, columns=headers)
print(user_df.head())
user_97581940
Related