How to store the string of the column in excel using python

Question

I have attached a screenshot of my excel sheet. I want to store the length of every string in SUPPLIER_id Length column. But when I run my code, CSV columns are blanks.

And when I use this same code in different CSV, it works well.

I am using following code but not able to print the data.

I have attached the snippet of csv. Can somebody tell me why is this happening:

import pandas as pd    
data = pd.read_csv(r'C:/Users/patesari/Desktop/python work/nba.csv')    
df = pd.DataFrame(data, columns= ['SUPPLIER_ID','ACTION'])    
data.dropna(inplace = True)    
data['SUPPLIER_ID']= data['SUPPLIER_ID'].astype(str)    
data['SUPPLIER_ID LENGTH']= data['SUPPLIER_ID'].str.len()    
data['SUPPLIER_ID']= data['SUPPLIER_ID'].astype(float)    
data    
print(df)    
data.to_csv("C:/Users/patesari/Desktop/python work/nba.csv")

Of course it would be empty because you are not doing anything with df. — amanb
– amanb, Commented Jun 20, 2019 at 7:42
(also please put code in codeblocks, here's how to do it, you can always check the little help button at the top right of your text box) — Nenri
– Nenri, Commented Jun 20, 2019 at 7:45
@amanb But he is saving the data variable and not the df. It should have worked. Don't you think the same? — Amazing Things Around You
– Amazing Things Around You, Commented Jun 20, 2019 at 7:45
@AmazingThingsAroundYou, a few problems with the code: 1) df is unnecessary 2) Type casting 'SUPPLIER_ID' to str first and then again to float doesn't make sense. 3) Reading from and writing to the same csv 4) We cannot be sure if the csv will have any data in the end, without looking at the actual data. — amanb
– amanb, Commented Jun 20, 2019 at 7:51

alphayama · Accepted Answer · 2019-06-20 08:32:08Z

1

I faced a similar problem in the past.

Instead of:

df = pd.DataFrame(data, columns= ['SUPPLIER_ID','ACTION'])

Type this:

data.columns=['SUPPLIER_ID','ACTION']

Also, I don't understand why did you create DataFrame df. It was unnecessary in my opinion.

answered Jun 20, 2019 at 8:32

alphayama

111 bronze badge

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

Comments

Rotem Tal · Accepted Answer · 2019-06-20 08:00:47Z

0

Aren't you getting a SettingWithCopyWarning from pandas? I would imagine (haven't ran this code) that these lines

data['SUPPLIER_ID']= data['SUPPLIER_ID'].astype(str)
data['SUPPLIER_ID LENGTH']= data['SUPPLIER_ID'].str.len()    
data['SUPPLIER_ID']= data['SUPPLIER_ID'].astype(float)

would not do anything, and should be replaced with

data.loc[:, 'SUPPLIER_ID']= data['SUPPLIER_ID'].astype(str)  
data.loc[:, 'SUPPLIER_ID LENGTH']= data['SUPPLIER_ID'].str.len()    
data.loc[:, 'SUPPLIER_ID']= data['SUPPLIER_ID'].astype(float)

answered Jun 20, 2019 at 8:00

Rotem Tal

7695 silver badges12 bronze badges

4 Comments

newuser Over a year ago

I am not getting any error,just my csv goes blank when i run the code

newuser Over a year ago

I tried your code snippet as well but its not working for me. Y it is so, that the same code is working for other csv files but not for other.

Rotem Tal Over a year ago

Are you sure the original csv had data in it? you're reading and writing to the same file, if you've done any mistake the data might have been erased, if this code works for other csv files it should work on this one as well.

newuser Over a year ago

yes.when i am reading my csv(instead to giving specific column name) as whole., few columns are gets erased.,i think that can be the issue.

Collectives™ on Stack Overflow

How to store the string of the column in excel using python

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related