How to delete the last row of data of a pandas dataframe

by

To drop last n rows:

df.drop(df.tail(n).index,inplace=True) # drop last n rows

By the same vein, you can drop first n rows:

df.drop(df.head(n).index,inplace=True) # drop first n rows

More Related Contents:

  1. Extract the data and modify an existing excel with openpyxl
  2. cartesian product in pandas
  3. Keep other columns when doing groupby
  4. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  5. What does `ValueError: cannot reindex from a duplicate axis` mean?
  6. Reconstruct a categorical variable from dummies in pandas
  7. Conditionally fill column values based on another columns value in pandas
  8. Remove duplicate rows from Pandas dataframe where only some columns have the same value
  9. Rename result columns from Pandas aggregation (“FutureWarning: using a dict with renaming is deprecated”)
  10. How to switch columns rows in a pandas dataframe
  11. Quickest way to make a get_dummies type dataframe from a column with a multiple of strings
  12. Using numpy.genfromtxt to read a csv file with strings containing commas
  13. Plot correlation matrix using pandas
  14. Insert a Pandas Dataframe into mongodb using PyMongo
  15. Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
  16. Copy pandas dataframe to excel using openpyxl
  17. Finding label location in a DataFrame Index
  18. Create new dataframe in pandas with dynamic names also add new column
  19. How to convert a dataframe to a dictionary
  20. Filling missing values using forward and backward fill in pandas dataframe (ffill and bfill)
  21. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  22. Querying for NaN and other names in Pandas
  23. Efficiently select rows that match one of several values in Pandas DataFrame [duplicate]
  24. Pandas Dataframe to Excel Sheet
  25. pandas: slice a MultiIndex by range of secondary index
  26. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  27. Pandas combining rows based on dates
  28. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  29. Preserving column order in Python Pandas DataFrame
  30. Multi Index Sorting in Pandas

Leave a Comment