使用pandas inot 12小时轮班7am - 7pm和7pm - 7am对数据进行分组

import pandas as pd

# 读取数据
data = pd.read_csv('data.csv')

# 数据预处理

# 创建时间列
data['Time'] = pd.to_datetime(data['Time'])

# 创建班次列
def get_shift(time):
    hour = time.hour
    if hour >= 7 and hour < 19:
        return 'Day Shift'
    else:
        return 'Night Shift'

data['Shift'] = data['Time'].apply(get_shift)

# 分组数据
grouped_data = data.groupby('Shift')

# 对分组后的数据进行聚合操作
shift_counts = grouped_data['Data'].count()
shift_sums = grouped_data['Data'].sum()
shift_means = grouped_data['Data'].mean()

# 打印结果
print("Shift Counts:")
print(shift_counts)

print("Shift Sums:")
print(shift_sums)

print("Shift Means:")
print(shift_means)