Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Working with date indexes (pandas)
#1
Hi all,
I have a dataset with time stamps and I am happy that I can use timestamps as indexes.
I have an issue though that I do not know how, I can make variables of time periods that the indexing will understand.

For example in the data below
data_test.index[0]

[22]:
Timestamp('2019-02-08 14:10:07.409000')

how I can pick with variables (with fixes string is easy) rows that are inside that time period?

Also how I can make a new time variable that now includes a shift?

For example something like

data_test.index[0].timedelta(milliseconds=500)


does not work but the idea is to be able to to have a rolling window based on time stamps that returns me subsets of the initial data frame (pandas).

Can you please suggest me which functions to use?

Thanks a lot
Alex
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Trying to Pass date to pandas search from input prompt curranjohn46 1 149 Oct-10-2019, 10:01 AM
Last Post: curranjohn46
  Need help passing date to pandas query curranjohn46 1 269 Oct-10-2019, 09:59 AM
Last Post: curranjohn46
  Pandas converting date to epoch randor 2 406 Jul-16-2019, 02:41 AM
Last Post: scidam
  replace nan values by mean group by date.year, date.month wissam1974 4 712 Jul-06-2019, 02:00 AM
Last Post: wissam1974
  import pandas as pd not working in pclinuxos loren41 3 309 May-19-2019, 03:49 PM
Last Post: Larz60+
  Pandas and Date: problem with operator.How to resolve frame 6 1,229 May-13-2019, 05:50 PM
Last Post: frame
  Error: Slicing a single date from Pandas cheerful 0 654 Jul-22-2018, 08:09 PM
Last Post: cheerful
  Finding date count from a list of date range in pandas trillerducas72 0 702 May-24-2018, 02:30 AM
Last Post: trillerducas72
  pandas convert date/time to week okl 3 2,670 Mar-03-2018, 10:15 PM
Last Post: marsokod
  pandas filter not working issac_n 10 2,943 Jan-11-2018, 08:28 AM
Last Post: issac_n

Forum Jump:


Users browsing this thread: 1 Guest(s)