Python pandas read a csv from one column then seperate columns

Question

I have a csv that needs seperation based on number of issues, and im currently getting an error with my code

 dfcleancsv = pd.read_csv('InitialQuerydataOpen.csv', sep=",")


ValueError: Expected 1 fields in line 1609, saw 55

What I have

Column1 Column2
1583    FIT-491
1584    FIT-4276,"TC 1140.0024, 1140.0025, 1140.0026, 1140.0179, 1140.018"

What I want

Column1 Column 2    Column3   Column4  Column5    Column6  Column7
1583    FIT-491
1584    FIT-4276  1140.0024 1140.0025 1140.0026 1140.0179 1140.018

michael_j_ward · Accepted Answer · 2016-06-02 18:19:54Z

2

Here you go:

with open('test.txt') as f:
        data = {i:txt.strip().split(',') for i,txt in enumerate(f.readlines())}

df = pd.DataFrame.from_dict(data, orient='index')
print(df)

## -- End pasted text --
      0          1          2          3          4          5         6
0  1583  FIT-491         None       None       None       None      None
1  1584   FIT-4276  1140.0024  1140.0025  1140.0026  1140.0179  1140.018

edited Jun 2, 2016 at 18:19

answered Jun 2, 2016 at 18:03

michael_j_ward

4,6891 gold badge27 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Python pandas read a csv from one column then seperate columns

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