Python Forum
Need help passing date to pandas query
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need help passing date to pandas query
#2
This is resolved.

I had to remove the single quotes around TestedDateBegin as python, of course, interpreted that as a string and not a variable. Duh. So simple.

data = df.loc[df[b]['emr_first_access_date'] >= TestedDateBegin,['site_name','subs_num','emr_id', 'emr_first_access_date']]
Reply


Messages In This Thread
RE: Need help passing date to pandas query - by curranjohn46 - Oct-10-2019, 09:59 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Pandas read csv file in 'date/time' chunks MorganSamage 4 1,701 Feb-13-2023, 11:24 AM
Last Post: MorganSamage
  Does a pandas have a date without a time? AlekseyPython 6 4,928 Feb-10-2021, 09:24 AM
Last Post: Naheed
  No Output In Pandas DataFrame Query eddywinch82 1 1,927 Aug-17-2020, 09:25 PM
Last Post: eddywinch82
  replace nan values by mean group by date.year, date.month wissam1974 5 8,456 Feb-19-2020, 06:25 PM
Last Post: AnkitGupta
  Obtaining Correct Date In Pandas DataFrame eddywinch82 14 5,985 Feb-17-2020, 11:45 AM
Last Post: eddywinch82
  Pandas Dataframe to Google Big Query Ecniv 2 3,037 Nov-21-2019, 02:26 PM
Last Post: Ecniv
  Trying to Pass date to pandas search from input prompt curranjohn46 1 2,108 Oct-10-2019, 10:01 AM
Last Post: curranjohn46
  Pandas converting date to epoch randor 2 3,912 Jul-16-2019, 02:41 AM
Last Post: scidam
  Pandas and Date: problem with operator.How to resolve frame 6 4,350 May-13-2019, 05:50 PM
Last Post: frame
  Working with date indexes (pandas) dervast 0 1,956 Apr-05-2019, 01:29 PM
Last Post: dervast

Forum Jump:

User Panel Messages

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