PANDAS: Wrong column names while importing data from csv file

Question

I am getting Wrong column names by this code: Why is this happening? Is there any other way to do this?

names = {'SYMBOL','CLMP'}
data2 = pd.read_csv(filePath +"\\"+ fileNameCM2+'.csv',skiprows = 1, index_col=False, names = names,header=None)
df3 = pd.DataFrame(data2)

print(df3.head())

OUTPUT:
          CLMP    SYMBOL
0         ACC    853921
1    ADANIENT   2758466
2  ADANIPORTS   7591819
3  ADANIPOWER  11774513
4  AJANTPHARM    257752

EXPECTED:
      SYMBOL      CLMP
0         ACC    853921
1    ADANIENT   2758466
2  ADANIPORTS   7591819
3  ADANIPOWER  11774513
4  AJANTPHARM    257752

Bharath M Shetty · Accepted Answer · 2018-01-05 05:46:59Z

1

Its because set will sort the names, instead use a list of columns names:

names = ['SYMBOL','CLMP']
df3 = pd.read_csv(filePath +"\\"+ fileNameCM2+'.csv',
                  skiprows = 1, 
                  index_col=False, 
                  names = names)

print (df)
       SYMBOL      CLMP
0         ACC    853921
1    ADANIENT   2758466
2  ADANIPORTS   7591819
3  ADANIPOWER  11774513
4  AJANTPHARM    257752

edited Jan 5, 2018 at 5:46

Bharath M Shetty

30.6k6 gold badges65 silver badges111 bronze badges

answered Jan 5, 2018 at 5:41

jezrael

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

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

3 Comments

aditass Over a year ago

Yes working fine, but what was {'SYMBOL','CLMP'} this doing?

jezrael Over a year ago

I think it is set, so order should be changed.

Bharath M Shetty Over a year ago

I thought OP was trying to sort the columns giving the names, didn't realise he was trying to change the names

Collectives™ on Stack Overflow

PANDAS: Wrong column names while importing data from csv file

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related