I try to read a text file, via:
pd.read_fwf('File.txt')
However, I can't pd.DataFrame
get the columns to be located correctly
index | Title\tProgram\tEmployee\tLast Name and First Name\tTerm |
---|---|
0 | 13\t961000\t452345\tJORGEMORALES\t2020-06-01 |
1 | 1\t210200\t46445\tMAURICIODIAZ\t2020-06-01 |
two | 22\t11000\t7564345\tRAULMORALES\t2020-09-01 |
I have also tried the following codes and got the same result:
pd.read_fwf('File.txt',encoding='latin1', sep = '\t')
pd.read_fwf('File.txt',encoding='latin1', delim_whitespace= True)