Python，Pandas:将DataFrame的内容写入文本文件 [英] Python, Pandas : write content of DataFrame into text File

问题描述

我有这样的pandas DataFrame

I have pandas DataFrame like this

        X    Y  Z    Value 
0      18   55  1      70   
1      18   55  2      67 
2      18   57  2      75     
3      18   58  1      35  
4      19   54  2      70   

我想将此数据写入如下所示的文本文件中:

I want to write this data to a text file that looks like this:

18 55 1 70   
18 55 2 67 
18 57 2 75     
18 58 1 35  
19 54 2 70 

我尝试过

f = open(writePath, 'a')
f.writelines(['\n', str(data['X']), ' ', str(data['Y']), ' ', str(data['Z']), ' ', str(data['Value'])])
f.close()

但是它不起作用.这该怎么做?

but it's not working. How to do this?

推荐答案

您可以只使用 np.savetxt 并访问np属性.values:

np.savetxt(r'c:\data\np.txt', df.values, fmt='%d')

产量:

18 55 1 70
18 55 2 67
18 57 2 75
18 58 1 35
19 54 2 70

或 to_csv :

df.to_csv(r'c:\data\pandas.txt', header=None, index=None, sep=' ', mode='a')

对于np.savetxt的注释，您必须传递使用附加模式创建的文件句柄.

Note for np.savetxt you'd have to pass a filehandle that has been created with append mode.

这篇关于Python，Pandas:将DataFrame的内容写入文本文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！