pd.DataFrame prints output in a single column

Question

I have a file which I'm trying to convert into data frame using pandas. It is inside a loop and returns me the output as shown below. Here is the code I'm using:

import pandas as pd
import csv
with open('File.tbl', 'r') as  f:
    P=list(f)
    del P[0]
for o in P:
    M=o.split()
    B= M[:4]             #selecting specific columns only
    E= pd.DataFrame(B)   #converting into DataFrame
    print(E)
    G.to_csv('para.csv', sep=',')

Here the tbl file is not tab seperated and to create a tab separation, I've to convert it into list. Here is the reult I'm getting:

The expected output is like this:

0    B   244  S  0

0    B   245  A  0

Any help will be highly appreciated.

U13-Forward · Accepted Answer · 2019-02-20 10:58:14Z

1

Try this:

import pandas as pd
import csv
df=pd.DataFrame()
with open('File.tbl', 'r') as  f:
    P=list(f)
    del P[0]
for o in P:
    M=o.split()
    B= M[:4]             #selecting specific columns only
    df = pd.concat([df,pd.DataFrame(B).T])    #converting into DataFrame
df.to_csv('para.csv', sep=',')

edited Feb 20, 2019 at 10:58

answered Feb 20, 2019 at 2:13

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

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

10 Comments

Sukrut Shishupal Over a year ago

Thanks for the reply, This is the result I'm getting: 0 B 244 S 0 0 1 2 3 0 B 245 A 0 Any idea how to remove those 0,1, 2, 3.

U13-Forward Over a year ago

@Dustrokes Edited mine.

Sukrut Shishupal Over a year ago

It worked, but now it's not getting converted into CSV file, the error I'm getting is this: 'str' object has no attribute 'to_csv'. I can convert the file using with open statements but would prefer to directly convert it into csv.

U13-Forward Over a year ago

@Dustrokes Edited mine, just viewd SO

Sukrut Shishupal Over a year ago

Hey, any idea how to convert the strings into csv file by directly using to_csv command?

|

Collectives™ on Stack Overflow

pd.DataFrame prints output in a single column

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related