excel pandas 空格_Pandas写入excel：1）索引中的空白行；2）每天保存索引

(1)模仿你的格式：import pandas as pd

from pandas import *

df = pd.read_csv('input.txt',sep=',',header=None,names=['Date','Column A','Column B'])

df = df.set_index(['Date'])

(2)重新编制索引：

^{pr2}$

(3)excelwriter = ExcelWriter('output.xlsx')

df.to_excel(writer,'Sheet1',index=False)

writer.save()

注：

对于excel writer，您需要openpyxl。轻松安装pip install openxl。关于这个的信息：https://openpyxl.readthedocs.org/en/latest/。

或者，对csv的写入将更为简单。在

ipython中上述步骤的实现示例：In [1]: import pandas as pd

In [2]: from pandas import *

In [3]: # 1. Mimicking your format:

In [4]: df = pd.read_csv('input.txt',sep=',',header=None,names=['Date','Column A','Column B'])

In [5]: pr