我有pandas数据帧。我想把它写在一个文本文件中,并在框架的顶部添加文本。
例如(这是数据。
0 <+000.0 +000.0 +050.0 +000.8>
1 <+000.0 +000.0 +049.1 +000.6>
2 <+000.0 +000.0 +047.6 +000.6>
3 <+000.0 +000.0 +046.5 +000.5>
4 <+000.0 +000.0 +045.3 +000.6>
我想把它写到文件(file.txt(中,但以下文本应该在文件中:
#my meas.
#done by me.
#pdd
0 <+000.0 +000.0 +050.0 +000.8>
1 <+000.0 +000.0 +049.1 +000.6>
2 <+000.0 +000.0 +047.6 +000.6>
3 <+000.0 +000.0 +046.5 +000.5>
4 <+000.0 +000.0 +045.3 +000.6>
由于我是新手,所以我只创建了数据帧并将其写入csv文件。
请帮忙。
您可以在顶部创建所需字符串的数据帧,然后附加主数据帧。在追加之前,请确保列名相同,以便它排列整齐(在我的示例中为0
(:
df = pd.DataFrame({0: {0: '<+000.0 +000.0 +050.0 +000.8>',
1: '<+000.0 +000.0 +049.1 +000.6>',
2: '<+000.0 +000.0 +047.6 +000.6>',
3: '<+000.0 +000.0 +046.5 +000.5>',
4: '<+000.0 +000.0 +045.3 +000.6>'}})
df = pd.DataFrame({0: ['#my meas.', '#done by me.', '#pdd', '']}).append(df)
df.to_csv(header=False, index=False)
df
Out[1]:
0
0 #my meas.
1 #done by me.
2 #pdd
3
0 <+000.0 +000.0 +050.0 +000.8>
1 <+000.0 +000.0 +049.1 +000.6>
2 <+000.0 +000.0 +047.6 +000.6>
3 <+000.0 +000.0 +046.5 +000.5>
4 <+000.0 +000.0 +045.3 +000.6>