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,360

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	554	Feb-13-2024, 11:13 PM Last Post: deanhystad
	Reading Specific Rows In a CSV File	finndude	3	1,101	Dec-13-2022, 03:19 PM Last Post: finndude
	Pymysql delete specific rows in tableview	stsxbel	2	1,185	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,706	Dec-08-2021, 04:42 AM Last Post: Jdesi1983
	[SOLVED] Delete specific characters from string lines	EnfantNicolas	4	2,408	Oct-21-2021, 11:28 AM Last Post: EnfantNicolas
	openpyxl incorrect delete rows	VladislavM	6	4,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,207	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,581	Mar-02-2021, 01:54 AM Last Post: Jeremy7
	How to sort rows based on specific order	Mekala	3	2,332	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,497	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