How to read a csv row wise and convert to a dataframe column using pandas?

Question

My dataset CSV file is row-wise:

1,2,3,4
1000,2000,3000,4000

I want to read this file and get a dataframe output of two columns, 'index and value'.

Output:

index value
1      1000
2      2000
3      3000

If I want to get only the 'value' column, I should be able to retrieve them by doing df['value']

I tried going about it like this:

series = pd.read_csv('file.csv',index_col=0, header=0)
df= series.T
Frame=pd.DataFrame([df], columns = ["index","value"])

But this yields an error:

> ValueError: Shape of passed values is (1, 1), indices imply (2, 1)

Mohamed Thasin ah · Accepted Answer · 2018-06-19 07:17:31Z

2

try this,

df=pd.read_csv('input.csv',header=None)
print df.T.rename(columns={0:'Index',1:'Value'})
print df['Value']

Out:

0    1000
1    2000
2    3000
3    4000
Name: Value, dtype: int64

edited Jun 19, 2018 at 7:17

answered Jun 19, 2018 at 7:08

Mohamed Thasin ah

11.2k11 gold badges65 silver badges120 bronze badges

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

11 Comments

Amogh Mishra Over a year ago

Throwing a KeyError: 'Value' when I print df['Value'].

Mohamed Thasin ah Over a year ago

@AmoghMishra - I'm not getting any key error. can you show your df before accessing df['Value']? this may rename doesn't work as expected

Amogh Mishra Over a year ago

yeah, my df is not returning a similar result. I don't get Name: Value, dtype: int64 in the end. Just to add more information, shape of df before transposing is (1,166) and after transposing (166,1)

Mohamed Thasin ah Over a year ago

@AmoghMishra- shape after transpose it will be like that only. It would be great if you print the result after transpose.

Amogh Mishra Over a year ago

This is the output of the df that I am getting 0 1000 1 2000 2 3000 3 4000 ... ... 166 166000 [166 rows x 1 columns]

|

Collectives™ on Stack Overflow

How to read a csv row wise and convert to a dataframe column using pandas?

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related