How to Create columns in txt file through pandas?

Question

Hello I read a gzip file into dataframe and when I was create columns name I take this:

However when I read the table the result is:

My quesstion is: I want to create 7 different columns but I can't. Each comma is a column . How can I do that?

@YakymPirozhenko Only sep=',' Space is excessive - it breaks datetime field 'created at'. — knagaev
– knagaev, Commented May 25, 2016 at 10:14
@knagaev you are correct - I did not notice the date and assumed the OP wanted to subdivide the existing dataframe. — hilberts_drinking_problem
– hilberts_drinking_problem, Commented May 25, 2016 at 13:47

Andreas Hsieh · Accepted Answer · 2016-05-24 22:41:43Z

2

Maybe you can try this:

import pandas as pd
df = pd.read_table('part-00000.gz', compression='gzip', sep=',', name=['search_id',...,'return'], header=None)

You can pass column names when you read gzip files. Hope this will help.

answered May 24, 2016 at 22:01

Andreas Hsieh

2,1601 gold badge12 silver badges9 bronze badges

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

1 Answer 1