Load data from txt with pandas

Question

I am loading a txt file containig a mix of float and string data  I want to store them in an array where I can access each element  Now I am just doing   import pandas as pd  data   pd read csv  output list txt   header   None  print data   This is the structure of the input file  1 0 2000 0 70 2836942112 1347 28369421  file address txt    Now the data are imported as a unique column  How can I divide it  so to store different elements separately  so I can call data i j    And how can I define a header

User · Answer

You can use it which is most helpful  df   pd read csv   data txt    sep  quot  t quot   skiprows  0 1   names   FromNode   ToNode

User · Answer

You can import the text file using the read table command as so   import pandas as pd df pd read table  output list txt  header None    Preprocessing will need to be done after loading

User · Answer

you can use this  import pandas as pd dataset pd read csv  filepath txt  delimiter   t

User · Answer

I usually take a look at the data first or just try to import it and do data head    if you see that the columns are separated with  t then you should specify sep   t  otherwise  sep         import pandas as pd      data   pd read csv  data txt   sep      header None

User · Answer

Pietrovismara s solution is correct but I d just like to add  rather than having a separate line to add column names  it s possible to do this from pd read csv   df   pd read csv  output list txt   sep      header None  names   a    b    c

User · Answer

You can use   data   pd read csv  output list txt   sep      header None  data columns     a    b    c    etc      Add sep     in your code  leaving a blank space between the quotes  So pandas can detect spaces between values and sort in columns  Data columns is for naming your columns

User · Answer

You can do as   import pandas as pd df   pd read csv  file location filename txt   delimiter     t      like  df   pd read csv  F  Desktop ds text txt   delimiter     t

User · Answer

If you want to load the txt file with specified column name  you can use the code below  It worked for me  import pandas as pd     data   pd read csv  file name txt   sep    quot  t quot   names     column1 name   column2 name    column3 name

User · Answer

Based on the latest changes in pandas  you can use  read csv   read table is deprecated   import pandas as pd pd read csv  file txt   sep     t

User · Answer

I d like to add to the above answers  you could directly use  df   pd read fwf  output list txt     fwf stands for fixed width formatted lines

User · Answer

If you don t have an index assigned to the data and you are not sure what the spacing is  you can use to let pandas assign an index and look for multiple spaces   df   pd read csv  filename txt   delimiter    s    index col False

[python] Load data from txt with pandas

Examples related to python

Examples related to io

Examples related to pandas