Pandas read in table without headers

by

In order to read a csv in that doesn’t have a header and for only certain columns you need to pass params header=None and usecols=[3,6] for the 4th and 7th columns:

df = pd.read_csv(file_path, header=None, usecols=[3,6])

See the docs

More Related Contents:

  1. Replacing values represented by 'UN' with NaN
  2. error when applying function to a series object
  3. How to group dataframe rows into list in pandas groupby
  4. Replace values in a pandas series via dictionary efficiently
  5. Get a list from Pandas DataFrame column headers
  6. How to convert string to datetime format in pandas python?
  7. How to insert pandas dataframe via mysqldb into database?
  8. Update a dataframe in pandas while iterating row by row
  9. SQLAlchemy ORM conversion to pandas DataFrame
  10. Pandas – Explanation on apply function being slow
  11. Pandas sum by groupby, but exclude certain columns
  12. Conditionally format Python pandas cell
  13. import csv with different number of columns per row using Pandas
  14. Selecting columns from pandas MultiIndex
  15. Pandas convert string to int
  16. Benefits of panda’s multiindex?
  17. Pandas pd.Series.isin performance with set versus array
  18. Convert pandas series from string to unique int ids [duplicate]
  19. Get week start date (Monday) from a date column in Python (pandas)?
  20. Pandas dataframe – running sum with reset
  21. Need of using ‘r’ before path-name while reading a csv file with pandas
  22. pandas.io.json.json_normalize with very nested json
  23. Python pandas convert datetime to timestamp effectively through dt accessor
  24. Time Series Analysis – unevenly spaced measures – pandas + statsmodels
  25. Move column by name to front of table in pandas
  26. Convert List to Pandas Dataframe Column
  27. matplotlib savefig() size control
  28. Is there a way to speed up handling large CSVs and dataframes in python?
  29. How to unpack a Series of tuples in Pandas?
  30. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?

Leave a Comment