Suppose you have an array of Dataframes. Each Dataframe contains the time and date of the datapoint in the DateTime format. Is there a way to filter/ remove rows from the DataFrame based on the time of day the data is recorded? So for example if I had the following DataFrame D. Data …

[image] phantom: D[@.(Time(9) <= Time(D.DateTime) <=Time(17), :] added missing parenthresis: D[@.(Time(9) <= Time(D.DateTime) <= Time(17)), :]

How to filter a DataFrame of DateTime data by the time of day?

bkamins April 26, 2022, 8:30pm 10

added missing parenthresis:

D[@.(Time(9) <= Time(D.DateTime) <= Time(17)), :]

1 Like

Topic		Replies	Views
Comparing times in a dataframe General Usage dataframes , datetime	2	204	March 26, 2024
Filtering DateTime range efficiently General Usage	0	435	September 5, 2017
Filter dataframe by date, e.g. yearmonth New to Julia dates	3	3152	August 20, 2019
Filtering Dataframe date column General Usage	8	613	October 9, 2023
Filter date from a feather DataFrame JULIA Data question , dataframes , arrow	4	632	January 3, 2022