start index at 1 for Pandas DataFrame

Index is an object, and default index starts from 0:

>>> result.index
Int64Index([0, 1, 2], dtype=int64)

You can shift this index by 1 with

>>> result.index += 1 
>>> result.index
Int64Index([1, 2, 3], dtype=int64)

Related Contents:

  1. Import multiple csv files into pandas and concatenate into one DataFrame
  2. How are iloc and loc different?
  3. UnicodeDecodeError when reading CSV file in Pandas with Python
  4. How to add pandas data to an existing csv file?
  5. Writing a pandas DataFrame to CSV file
  6. What is the difference between using squared brackets or dot to access a column?
  7. Import CSV file as a pandas DataFrame
  8. How to reset index in a pandas dataframe? [duplicate]
  9. What rules does Pandas use to generate a view vs a copy?
  10. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  11. How to convert index of a pandas dataframe into a column
  12. Pandas split DataFrame by column value
  13. Selecting a row of pandas series/dataframe by integer index
  14. How to avoid Python/Pandas creating an index in a saved csv?
  15. datetime dtypes in pandas read_csv
  16. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  17. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  18. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  19. Pandas split column into multiple columns by comma
  20. python – Using pandas structures with large csv(iterate and chunksize)
  21. Read CSV into a dataFrame with varying row lengths using Pandas
  22. How to avoid pandas creating an index in a saved csv
  23. Python Pandas: Get index of rows where column matches certain value
  24. Get column index from column name in python pandas
  25. pandas DataFrame output end of csv
  26. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  27. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  28. UnicodeDecodeError when reading CSV file in Pandas
  29. Python: Removing Rows on Count condition
  30. How to add header row to a pandas DataFrame
  31. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  32. Loading multiple csv files of a folder into one dataframe
  33. Using replace efficiently in pandas
  34. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  35. Replacing blank values (white space) with NaN in pandas
  36. How to replace text in a string column of a Pandas dataframe?
  37. Pandas DataFrame to List of Dictionaries
  38. Normalize columns of pandas data frame
  39. Pretty Printing a pandas dataframe
  40. Calculate average of every x rows in a table and create new table
  41. How to calculate mean values grouped on another column in Pandas
  42. Python – How to convert JSON File to Dataframe
  43. Combining two Series into a DataFrame in pandas
  44. Return multiple columns from pandas apply()
  45. Get first row value of a given column
  46. Cumsum as a new column in an existing Pandas dataframe
  47. How to get/set a pandas index column title or name?
  48. Select row by max value in group in a pandas dataframe
  49. How to drop unique rows in a pandas dataframe?
  50. Split pandas dataframe in two if it has more than 10 rows

Leave a Comment