Python Forum
Find and delete above a certain line in text file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Find and delete above a certain line in text file
#11
StringIO as i used is not needed when read from a file.
It make the string i copied from you post act like a file-like object in memory..
import pandas as pd

df = pd.read_csv("data.csv", names=["Date", "Time", "Comment"])
df['DateTime'] = pd.to_datetime(df["Date"] + df["Time"])
mask = (df['DateTime'] >= '2022-03-08 16:15:00')
df_new = df.loc[mask]
#df_new = df_new.drop(columns=['DateTime'])
df_new = df_new.drop(columns=['Date', 'Time'])
print(df_new)
Output:
Comment DateTime 6 String Value 2022-03-08 16:15:00 7 String Value 2022-03-08 16:15:00 8 String Value 2022-03-08 16:15:00 9 String Value 2022-03-08 16:15:00 10 String Value 2022-03-08 16:17:00 11 String Value 2022-03-08 16:17:00
Line 7 uncomment:
Output:
Date Time Comment 6 3/8/22 4:15 PM String Value 7 3/8/22 4:15 PM String Value 8 3/8/22 4:15 PM String Value 9 3/8/22 4:15 PM String Value 10 3/8/22 4:17 PM String Value 11 3/8/22 4:17 PM String Value
Reply
#12
I am guessing this is a typo:
mask = (df['DateTime'] > '2022-03-08 16:06:00') & (df['DateTime'] >= '2022-03-08 16:15:00')
Any datetime > '2022-03-08 16:06:00' is also >= '2022-03-08 16:15:00'.
Maybe it was going to be an example of a start and end datetime.
mask = (df['DateTime'] > '2022-03-08 16:06:00') & (df['DateTime'] <= '2022-03-08 16:15:00')
Reply
#13
(Mar-18-2022, 05:52 PM)deanhystad Wrote: Maybe it was going to be an example of a start and end datetime.
Yes that was the idea,thx for the correction.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  FileNotFoundError: [WinError 2] The system cannot find the file specified NewBiee 2 1,396 Jul-31-2023, 11:42 AM
Last Post: deanhystad
  File "<string>", line 19, in <module> error is related to what? Frankduc 9 12,177 Mar-09-2023, 07:22 AM
Last Post: LocklearSusan
  Cannot find py credentials file standenman 5 1,484 Feb-25-2023, 08:30 PM
Last Post: Jeff900
  selenium can't find a file in my desk ? SouAmego22 0 674 Feb-14-2023, 03:21 PM
Last Post: SouAmego22
  Pypdf2 will not find text standenman 2 836 Feb-03-2023, 10:52 PM
Last Post: standenman
  Getting last line of each line occurrence in a file tester_V 1 776 Jan-31-2023, 09:29 PM
Last Post: deanhystad
Thumbs Up Need to compare the Excel file name with a directory text file. veeran1991 1 1,009 Dec-15-2022, 04:32 PM
Last Post: Larz60+
  Find (each) element from a list in a file tester_V 3 1,098 Nov-15-2022, 08:40 PM
Last Post: tester_V
  Writing string to file results in one character per line RB76SFJPsJJDu3bMnwYM 4 1,233 Sep-27-2022, 01:38 PM
Last Post: buran
  Graphic line plot with matplotlib, text file in pytho khadija 2 1,301 Aug-15-2022, 12:00 PM
Last Post: khadija

Forum Jump:

User Panel Messages

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