How to write excel row in python using pandas

Question

I am reading a row from an excel file and trying to write it back to excel as row but it writes as column, I am using pandas

import pandas as pd 
import xlsxwriter as xlsw

cols = [1, 2, 3, 4, 5, 6, 7]
df = pd.read_excel('test.xlsx', sheet_names='Sheet1', usecols=cols)
df.head()
dfr = df.iloc[6]
dfr = pd.DataFrame(dfr,columns=['Voltage', 'Amps', 'Expected 
Voltage','Expected Current', 'ExpectedLogicalValue', 'Actual Voltage'])

writer = pd.ExcelWriter('Output.xlsx', engine='xlsxwriter')
dfr.to_excel(writer, sheet_name="data", index=False)
writer.save()

xlsxwriter.readthedocs.io/working_with_pandas.html

Mayur
– Mayur

2019-01-28 11:12:17 +00:00
Commented Jan 28, 2019 at 11:12 — Mayur
– Mayur, Commented Jan 28, 2019 at 11:12

jezrael · Accepted Answer · 2019-01-28 11:10:04Z

3

I think you need select by double list for one row DataFrame and then set new columns names:

dfr = df.iloc[[6]]
dfr.columns= = ['Voltage', 'Amps', 'Expected Voltage','Expected Current', 
                'ExpectedLogicalValue', 'Actual Voltage', 'Another col']

Another solution:

cols = [1, 2, 3, 4, 5, 6, 7]
names = ['Voltage', 'Amps', 'Expected Voltage','Expected Current', 
         'ExpectedLogicalValue', 'Actual Voltage', 'Another col']

df = pd.read_excel('test.xlsx', sheet_names='Sheet1', usecols=cols, names=names, skiprows=1)

dfr = df.iloc[[6]]

answered Jan 28, 2019 at 11:10

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim Over a year ago

I edited this line of my code and everything worked dfr = df.iloc[[6]]

Collectives™ on Stack Overflow

How to write excel row in python using pandas

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related