Python | Фрейм данных Pandas.between_time ()
Python - отличный язык для анализа данных, в первую очередь из-за фантастической экосистемы пакетов Python, ориентированных на данные. Pandas - один из таких пакетов, который значительно упрощает импорт и анализ данных.
Pandas dataframe.between_time() is used to select values between particular times of the day (e.g. 9:00-9:30 AM). Unlike dataframe.at_time() function, this function extracts values in a range of time. This function is only used with time-series data. The index of the Dataframe must be DatetimeIndex in order to be able to use this function.
Syntax: DataFrame.between_time(start_time, end_time, include_start=True, include_end=True)
Parameters:
start_time : datetime.time or string
end_time : datetime.time or string
include_start : boolean, default True
include_end : boolean, default TrueReturns: values_between_time : type of caller
Note: between_time() function raises exception when the index of the dataframe is not a DatetimeIndex
Example #1: Use between_time() function to find the values between a given time interval.
# importing pandas as pdimport pandas as pd # Creating row index values for dataframe# Taken time frequency to be of 30 minutes interval# Generating eight index value using "period = 8" parameterind = pd.date_range("01/01/2000", periods = 8, freq ="30T") # Creating a dataframe with 2 columns# using "ind" as the index for dataframe df = pd.DataFrame({"A":[1, 2, 3, 4, 5, 6, 7, 8], "B":[10, 20, 30, 40, 50, 60, 70, 80]}, index = ind) # Printing the dataframedf |
Now let’s query for time between “02:00” to “03:30”
# Find the row values between time "02:00" to "03:30"df.between_time("02:00", "03:30") |
Output :
Example #2: Use between_time() function to find the values between a given time interval while excluding the start and end times.
# importing pandas as pdimport pandas as pd # Creating row index values for our data frame# Taken time frequency to be of 30 minutes interval# Generating eight index value using "period = 8" parameterind = pd.date_range("01/01/2000", periods = 8, freq ="30T") # Creating a dataframe with 2 columns# using "ind" as the index for our dataframe df = pd.DataFrame({"A":[1, 2, 3, 4, 5, 6, 7, 8], "B":[10, 20, 30, 40, 50, 60, 70, 80]}, index = ind) # query for time between "02:00" to "03:30" with# both the start and end time values being excludeddf.between_time("02:00", "03:30", include_start = False, include_end = False) |
Выход :
Notice the values corresponding to start time and end time is not included in the dataframe returned by the between_time() function.
Внимание компьютерщик! Укрепите свои основы с помощью базового курса программирования Python и изучите основы.
Для начала подготовьтесь к собеседованию. Расширьте свои концепции структур данных с помощью курса Python DS. А чтобы начать свое путешествие по машинному обучению, присоединяйтесь к курсу Машинное обучение - базовый уровень.