I would strongly suggest to use
df.to_csv("mydata.csv", index=False)
this would display your data in a excel sheet
where df here would be the name of the data frame