import text to pandas with multiple delimiters

by

One way might be to use the regex separators permitted by the python engine. For example:

>>> !cat castle.dat
c stuff
c more header
c begin data         
 1 1:.5
 1 2:6.5
 1 3:5.3
>>> df = pd.read_csv('castle.dat', skiprows=3, names=['a', 'b', 'c'], 
                     sep=' |:', engine="python")
>>> df
   a  b    c
0  1  1  0.5
1  1  2  6.5
2  1  3  5.3

More Related Contents:

  1. Import multiple csv files into pandas and concatenate into one DataFrame
  2. Writing a pandas DataFrame to CSV file
  3. Pandas read_csv from url
  4. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  5. Python Pandas Error tokenizing data
  6. How to read a file with a semi colon separator in pandas
  7. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  8. How to read file with space separated values in pandas
  9. pandas read_csv and filter columns with usecols
  10. selecting across multiple columns with python pandas?
  11. Pandas: ValueError: cannot convert float NaN to integer
  12. pandas DataFrame output end of csv
  13. How to read a column of csv as dtype list using pandas?
  14. Use Multiple Character Delimiter in Python Pandas read_csv
  15. Get pandas.read_csv to read empty values as empty string instead of nan
  16. Panda’s Write CSV – Append vs. Write
  17. Loading multiple csv files of a folder into one dataframe
  18. python pandas read_csv delimiter in column data
  19. Read csv from Google Cloud storage to pandas dataframe
  20. Pandas dataframe read_csv on bad data
  21. Pandas read_csv dtype leading zeros
  22. pandas.read_csv from string or package data
  23. Conditional row read of csv in pandas
  24. Pandas read_csv dtype read all columns but few as string
  25. Calculate summary statistics of columns in dataframe
  26. double quoted elements in csv cant read with pandas
  27. how to specify the datetime format in read_csv
  28. UnicodeDecodeError when reading CSV file in Pandas
  29. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  30. Pandas df.to_csv(“file.csv” encode=”utf-8″) still gives trash characters for minus sign

Leave a Comment