Pandas (python): How to add column to dataframe for index?

by

How about:

df['new_col'] = range(1, len(df) + 1)

Alternatively if you want the index to be the ranks and store the original index as a column:

df = df.reset_index()

Related Contents:

  1. How are iloc and loc different?
  2. How to convert index of a pandas dataframe into a column
  3. Selecting a row of pandas series/dataframe by integer index
  4. How to reset index in a pandas dataframe? [duplicate]
  5. Get column index from column name in python pandas
  6. pandas: multiple conditions while indexing data frame – unexpected behavior
  7. Python Pandas: Get index of rows where column matches certain value
  8. What rules does Pandas use to generate a view vs a copy?
  9. Pandas split DataFrame by column value
  10. Apply Function on DataFrame Index
  11. Forcing pandas .iloc to return a single-row dataframe?
  12. start index at 1 for Pandas DataFrame
  13. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  14. Select only one index of multiindex DataFrame
  15. pandas – change df.index from float64 to unicode or string
  16. Pandas – Compute z-score for all columns
  17. In Python pandas, start row index from 1 instead of zero without creating additional column
  18. Set MultiIndex of an existing DataFrame in pandas
  19. Accessing a Pandas index like a regular column
  20. obtaining last value of dataframe column without index
  21. Delete a column from a Pandas DataFrame
  22. How do I get the row count of a Pandas DataFrame?
  23. How to change the order of DataFrame columns?
  24. How to add a new column to an existing DataFrame?
  25. Convert Python dict into a dataframe
  26. How do I create test and train samples from one dataframe with pandas?
  27. Convert a Pandas DataFrame to a dictionary
  28. Detect and exclude outliers in a pandas DataFrame
  29. Concatenate a list of pandas dataframes together
  30. Python Pandas – Find difference between two data frames
  31. Python Pandas replace NaN in one column with value from corresponding row of second column
  32. How to convert a dataframe to a dictionary
  33. Update row values where certain condition is met in pandas
  34. How to read a Parquet file into Pandas DataFrame?
  35. Joining pandas DataFrames by Column names
  36. Python: get a frequency count based on two columns (variables) in pandas dataframe some row appers
  37. Difference between groupby and pivot_table
  38. Convert pandas DataFrame into list of lists [duplicate]
  39. How to repeat a Pandas DataFrame?
  40. Data type conversion error: ValueError: Cannot convert non-finite values (NA or inf) to integer [duplicate]
  41. USING LIKE inside pandas.query()
  42. How to query MultiIndex index columns values in pandas
  43. How to get/set a pandas index column title or name?
  44. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it
  45. Check if all values in dataframe column are the same
  46. How do I transpose dataframe in pandas without index?
  47. How to convert list to row dataframe with Pandas
  48. Python pandas groupby aggregate on multiple columns, then pivot
  49. Count number of elements in each column less than x
  50. Split pandas dataframe in two if it has more than 10 rows

Leave a Comment