Insert a series into specific column of a CSV file using Pandas Python

Question

I am reading a XLS file and fetching the contents of a single column into a series 'username'. Now I want to insert the series into a CSV file which has a column named as 'Username'. I am having trouble doing this.

#Reading XLS File
excel_file = 'Some Report.xls'
sm_file = pd.read_excel(excel_file)

#Series
usernames = sm_file['Whois']

Now, I want to insert this series into "Username" column of "test.csv" file.
Test.csv file has many columns and I want to identify "Username" column and insert this series into that column.

I am facing difficulty while doing the same as I'm new in python & pandas.

Divide your task into subproblems! Your first problem would be how to identify the "Username" column. Try that and tell us how it went! — peer
– peer, Commented Feb 3, 2019 at 17:38

amanb · Accepted Answer · 2019-02-03 17:49:53Z

1

Assuming the Whois column contains the usernames in the xls file, first read the csv 'test.csv' into memory:

import pandas as pd
usernames = sm_file['Whois']
testdf = pd.read_csv('test.csv')

Now, if the 'Usernames' column already exists in 'test.csv', then you can just select the column and assign the usernames series value to it. This is also assuming that the index length is same across the series and the testdf dataframe:

testdf['Usernames'] = usernames
testdf.to_csv('test.csv', encoding='utf-8', index=False, header=True)

I hope this helps.

answered Feb 3, 2019 at 17:49

amanb

5,4733 gold badges21 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Insert a series into specific column of a CSV file using Pandas Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related