Columns names issues using pandas.read_csv

Question

I am pretty new to python. I am trying to import the SMSSpam Collection Data using pandas read_csv module. I The import went went. But as the file does not have header I tried to include columns names(variables names : "status" and "message" and ended up with empty file. Here is my code:

import numpy as np
import pandas as pd
file_loc="C:\Users\User\Documents\JP\SMSCollection.txt"
df=pd.read_csv(file_loc,sep='\t')

The above code works well I got the I got the 5571 rows x 2 columns]. But when I add columns using the following line of code

df.columns=["status","message"]

I ended up with an empty df Any help on this ? Thanks

Are you trying to rename existing columns in the dataframe or add new columns to the dataframe? — asongtoruin
– asongtoruin, Commented Aug 7, 2018 at 10:38

ejb · Accepted Answer · 2018-08-07 10:17:58Z

1

You could try to set the column names at read time:

df=pd.read_csv(file_loc,sep='\t',header=None,names=["status","message"])

answered Aug 7, 2018 at 10:17

ejb

1458 bronze badges

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

Collectives™ on Stack Overflow

Columns names issues using pandas.read_csv

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