如何读取文本文件作为输入，并使用熊猫写入excel列？

Question

我使用permission.txt文件作为输入，并希望将数据写入Excel-2007的列中(我使用的是熊猫XlsxWriter，因为我想要超过256个列)。我想这样写到excel文件中。我已经尝试了下面的代码，这些代码以行形式写入数据，而不是将数据写入列(列1，列2......column 400)。

import pandas as pd
from pandas import ExcelWriter
from pandas import ExcelFile
import numpy as np


data = pd.read_csv('F:/Research_Work/python/Permission.txt', sep=" ", header=None)
writer = ExcelWriter('Example2.xlsx')
data.to_excel(writer,'Sheet1',index=False)

Answer 1

您只需转换数据数据，如下所示：

import pandas as pd

# Create a Pandas dataframe from some data.
df1 = pd.DataFrame({'Data': [10, 20, 30, 40]})
df2 = df1.T

# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')

# Write the data in column and transposed (row) directions.
df1.to_excel(writer, sheet_name='Sheet1', 
             startrow=1, startcol=1, header=False, index=False)

df2.to_excel(writer, sheet_name='Sheet1', 
             startrow=1, startcol=3, header=False, index=False)

# Close the Pandas Excel writer and output the Excel file.
writer.save()

输出：

​

​