Trying to delete rows above a specific datetime value

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Trying to delete rows above a specific datetime value

deanhystad

Super Moderators

Posts: 6,347

Threads: 17

Joined: Feb 2020

Reputation: 315

#12

May-06-2022, 04:39 PM (This post was last modified: May-06-2022, 04:40 PM by deanhystad.)

Create a new column which combines date and time. Remove items that are older than you threshold. Drop the datetime column you created. Write dataframe to CSV file.

Find

Messages In This Thread

Trying to delete rows above a specific datetime value - by cubangt - May-05-2022, 09:45 PM

RE: Trying to delete rows above a specific datetime value - by deanhystad - May-05-2022, 10:12 PM

RE: Trying to delete rows above a specific datetime value - by Pedroski55 - May-06-2022, 07:45 AM

RE: Trying to delete rows above a specific datetime value - by snippsat - May-06-2022, 10:17 AM

RE: Trying to delete rows above a specific datetime value - by cubangt - May-06-2022, 01:40 PM

RE: Trying to delete rows above a specific datetime value - by deanhystad - May-06-2022, 01:43 PM

RE: Trying to delete rows above a specific datetime value - by cubangt - May-06-2022, 01:51 PM

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

RE: Trying to delete rows above a specific datetime value - by deanhystad - May-06-2022, 02:05 PM

RE: Trying to delete rows above a specific datetime value - by cubangt - May-06-2022, 02:07 PM

RE: Trying to delete rows above a specific datetime value - by cubangt - May-06-2022, 02:46 PM

RE: Trying to delete rows above a specific datetime value - by deanhystad - May-06-2022, 04:39 PM

RE: Trying to delete rows above a specific datetime value - by cubangt - May-06-2022, 06:08 PM

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

RE: Trying to delete rows above a specific datetime value - by cubangt - May-06-2022, 09:01 PM

RE: Trying to delete rows above a specific datetime value - by deanhystad - May-06-2022, 10:33 PM

RE: Trying to delete rows above a specific datetime value - by cubangt - May-09-2022, 01:43 PM

RE: Trying to delete rows above a specific datetime value - by cubangt - May-09-2022, 08:19 PM

RE: Trying to delete rows above a specific datetime value - by cubangt - May-09-2022, 08:46 PM

RE: Trying to delete rows above a specific datetime value - by deanhystad - May-09-2022, 08:57 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	delete specific row of entries	jacksfrustration	3	531	Feb-13-2024, 11:13 PM Last Post: deanhystad
	Reading Specific Rows In a CSV File	finndude	3	1,079	Dec-13-2022, 03:19 PM Last Post: finndude
	Pymysql delete specific rows in tableview	stsxbel	2	1,156	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	1,691	Dec-08-2021, 04:42 AM Last Post: Jdesi1983
	[SOLVED] Delete specific characters from string lines	EnfantNicolas	4	2,366	Oct-21-2021, 11:28 AM Last Post: EnfantNicolas
	openpyxl incorrect delete rows	VladislavM	6	4,336	Jul-19-2021, 08:54 AM Last Post: VladislavM
	Pandas DataFrame combine rows by column value, where Date Rows are NULL	rhat398	0	2,199	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	7,524	Mar-02-2021, 01:54 AM Last Post: Jeremy7
	How to sort rows based on specific order	Mekala	3	2,303	Jul-31-2020, 01:01 AM Last Post: bowlofred
	How to extract specific rows and columns from a text file with Python	Farhan	0	3,481	Mar-25-2020, 09:18 PM Last Post: Farhan

Users browsing this thread: 2 Guest(s)

View a Printable Version

Trying to delete rows above a specific datetime value

User Panel Messages

Announcements