How to align left in pandas when read txt file

Question

I have a info.txt file it looks like this:

B 19960331 00100000 00000000000000 00000000000000 00000000000000 00000000 00000000000000 00000000000000 00000000000000
B 19960430 00099100 00000000000000 00000000000000 00000000000000 00000000 00000000000000 00000000000000 00000000000000
B 19960531 00098500 00000000000000 00000000000000 00000000000000 00000000 00000000000000 00000000000000 00000000000000

And when I use pandas to read it:

import pandas as pd
import numpy as np
df =pd.read_csv('C:\Users\Petter\Desktop\info.txt')
df

and the output is:

    B 19960331 00100000 00000000000000 00000000000000 00000000000000 00000000 00000000000000 00000000000000 00000000000000
                                                                     0  B 19960430 00099100 00000000000000 00000000000...
                                                                     1  B 19960531 00098500 00000000000000 00000000000...

The rows are far right from the column name,is there anyway I can make them like this:

    B 19960331 00100000 00000000000000 00000000000000 00000000000000 00000000 00000000000000 00000000000000 00000000000000
0   B 19960430 00099100 00000000000000 00000000000...
1   B 19960531 00098500 00000000000000 00000000000...

I tried:

df.shift(periods=1, axis="columns")

but now work

Andrej Kesely · Accepted Answer · 2021-06-22 17:15:43Z

2

You can try to read the file with pd.read_csv:

df = pd.read_csv("your_file.txt", sep=r"\s", header=None, dtype=str, engine="python")
print(df)

Prints:

   0         1         2               3               4               5         6               7               8               9
0  B  19960331  00100000  00000000000000  00000000000000  00000000000000  00000000  00000000000000  00000000000000  00000000000000
1  B  19960430  00099100  00000000000000  00000000000000  00000000000000  00000000  00000000000000  00000000000000  00000000000000
2  B  19960531  00098500  00000000000000  00000000000000  00000000000000  00000000  00000000000000  00000000000000  00000000000000

answered Jun 22, 2021 at 17:15

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

3 Comments

William Over a year ago

Thank you so much for your help sir, can you help me with this one stackoverflow.com/questions/68088484/…

William Over a year ago

Hi sir, thank you so much for your help,can you help with this question:Hi sir,can you help with this question stackoverflow.com/questions/68090116/…

William Over a year ago

Hi @Andrej friend,can you help me with this question stackoverflow.com/questions/68309137/…

Collectives™ on Stack Overflow

How to align left in pandas when read txt file

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related