Read CSV into a dataFrame with varying row lengths using Pandas

by

If using only pandas, read in lines, deal with the separator after. 

import pandas as pd

df = pd.read_csv('data.csv', header=None, sep='\n')
df = df[0].str.split('\s\|\s', expand=True)

   0           1    2     3     4     5     6
0  1  01-01-2019  724  None  None  None  None
1  2  01-01-2019  233   436  None  None  None
2  3  01-01-2019  345  None  None  None  None
3  4  01-01-2019  803   933   943   923   954
4  5  01-01-2019  454  None  None  None  None

More Related Contents:

  1. Import multiple csv files into pandas and concatenate into one DataFrame
  2. UnicodeDecodeError when reading CSV file in Pandas with Python
  3. How to add pandas data to an existing csv file?
  4. Writing a pandas DataFrame to CSV file
  5. Import CSV file as a pandas DataFrame
  6. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  7. datetime dtypes in pandas read_csv
  8. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  9. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  10. Pandas split column into multiple columns by comma
  11. python – Using pandas structures with large csv(iterate and chunksize)
  12. pandas DataFrame output end of csv
  13. OSError: Initializing from file failed on csv in Pandas
  14. Loading multiple csv files of a folder into one dataframe
  15. How to add header row to a pandas DataFrame
  16. Is there a way to speed up handling large CSVs and dataframes in python?
  17. How do you remove the column name row when exporting a pandas DataFrame?
  18. Calculate summary statistics of columns in dataframe
  19. pandas dataframe with 2-rows header and export to csv
  20. UnicodeDecodeError when reading CSV file in Pandas
  21. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  22. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  23. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  24. start index at 1 for Pandas DataFrame
  25. How can I map True/False to 1/0 in a Pandas DataFrame?
  26. Pandas deleting row with df.drop doesn’t work
  27. How can I subclass a Pandas DataFrame?
  28. Convert List to Pandas Dataframe Column
  29. dataframe to dict such that one column is the key and the other is the value [duplicate]
  30. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df

Leave a Comment