python pandas read_fwf separate by \t

Asked Nov 24 '21 at 16:58

Active Nov 24 '21 at 16:58

Viewed 440 times

I have tried these variations,

df = pd.read_fwf("test.txt", sep='\t', header = 20, engine='python')
df = pd.read_fwf("test.txt", sep=r'\\t', header = 20, engine='python')
df = pd.read_fwf("test.txt", sep='\\\\t', header = 20, engine='python')

print(list(df.columns.values))

The result I get is,

['Column1name\tColumn2name\tColumn3name\tColumn4name\tColumn5name']

asked Nov 24 '21 at 16:58

Python account

Please show a sample of your `text.txt` file, in the question. – Nov 24 '21 at 17:01
are you sure you have fixed-width formatted lines file ? – eshirvana Nov 24 '21 at 17:08
It's a .txt file and the columns are separated by a tab, so I think it is a fixed width formatted file – Python account Nov 24 '21 at 17:10
1

Can you upload it somewhere, e.g. to pastebin.com? I can't reproduce. – Nov 24 '21 at 17:24
Unfortunately I can't upload as it's work related. I tried separating by a space just to see if it would work, some column names have spaces in them, oddly it came it exactly the same as above. – Python account Nov 24 '21 at 18:25

python pandas read_fwf separate by \t

0 Answers0