Reading a text file using Pandas accurately in Python

Question

I am trying to read B.txt using pandas. It prints the value of B but not as a list. I present the current and expected outputs.

import pandas as pd

df = pd.read_csv("B.txt", header=None)
B = df. to_numpy()
B=B.tolist()
print("B =",B)

The current output is

B = [['B=3']]

The expected output is

B=[3]

I skipped some lines but still I am not getting the expected output. I have updated the current output above. — user20032724
– user20032724, Commented Sep 21, 2022 at 8:33

jezrael · Accepted Answer · 2022-09-21 08:37:54Z

1

Add squeeze = True for Series, so ouput is B = ['B=3'], select first value and split, select second value and convert to int:

s  = pd.read_csv("B.txt", header=None, squeeze = True)
print (s)
0    B=3
Name: 0, dtype: object

print (s.iat[0])
B=3
print (s.iat[0].split('='))
['B', '3']

print (s.iat[0].split('=')[1])
3

print("B =", int(s.iat[0].split('=')[1]))
B = 3

edited Sep 21, 2022 at 8:37

answered Sep 21, 2022 at 8:32

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Reading a text file using Pandas accurately in Python

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