python.pandas read and write CSV file

最新推荐文章于 2024-12-20 21:17:36 发布

weixin_34342905

最新推荐文章于 2024-12-20 21:17:36 发布

阅读量201

点赞数

文章标签： python

#read and write csv of pandas
import pandas as pd

goog =pd.read_csv(r'C:\python\demo\LiaoXueFeng\data\test_vrt.csv',index_col=0)
goog=goog.reindex(pd.to_datetime(goog.index))
print(goog.head())
print(goog.tail())

data2 = [{'july': 9999, 'han': 5000, 'zewei': 1000}, {'july': 9999, 'han': 5000, 'zewei': 1000},
         {'july': 9999, 'han': 5000, 'zewe2i': 1000}]
df3 = pd.DataFrame(data2)
df3.to_csv(r'C:\python\demo\LiaoXueFeng\data\goog2.csv',encoding='GBK',mode='a')