Python Forum
Trying to delete rows above a specific datetime value
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Trying to delete rows above a specific datetime value
#14
Got it working.. thank you for the suggestion, i updated the code to this and produced the correct results in the updated/new csv file

# THIS OPENS THE NEWLY CLEAN DATA IN ORDER TO REMOVE OLD RECORDS
df = pd.read_csv("Dates.txt", usecols=range(3), header=None, names=["Date", "Time", "Comment"])
# THIS CONVERTS THE DATE COLUMN INTO A DATETIME FORMAT
df['DT'] = pd.to_datetime(df['Date'] + ' ' + df['Time'])
# HERE YOU NEED TO PROVIDE THE DATE YOU WANT TO KEEP GOING FORWARD
mask = (df['DT'] > '2022-04-28  7:06 AM')
# THIS RETURNS ALL ROWS GREATER THAN THE DATE PROVIDED ABOVE
ndf = df.loc[mask]
Reply


Messages In This Thread
RE: Trying to delete rows above a specific datetime value - by cubangt - May-06-2022, 06:58 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  delete specific row of entries jacksfrustration 3 1,456 Feb-13-2024, 11:13 PM
Last Post: deanhystad
  Reading Specific Rows In a CSV File finndude 3 1,954 Dec-13-2022, 03:19 PM
Last Post: finndude
  Pymysql delete specific rows in tableview stsxbel 2 1,940 Aug-18-2022, 09:50 AM
Last Post: ibreeden
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 2,213 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
Question [SOLVED] Delete specific characters from string lines EnfantNicolas 4 3,399 Oct-21-2021, 11:28 AM
Last Post: EnfantNicolas
  openpyxl incorrect delete rows VladislavM 6 6,388 Jul-19-2021, 08:54 AM
Last Post: VladislavM
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,808 May-04-2021, 10:51 PM
Last Post: rhat398
  Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python Jeremy7 8 10,320 Mar-02-2021, 01:54 AM
Last Post: Jeremy7
  How to sort rows based on specific order Mekala 3 3,228 Jul-31-2020, 01:01 AM
Last Post: bowlofred
  How to extract specific rows and columns from a text file with Python Farhan 0 4,232 Mar-25-2020, 09:18 PM
Last Post: Farhan

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020