1.3 KiB
1.3 KiB
In [8]:
import pandas
df = pandas.read_csv("data/cbec-robot-info/robot-name-temu-clear-manual.csv")
# Convert Name column to uppercase
df["Name"] = df["Name"].str.upper()
# Remove duplicates
df = df.drop_duplicates()
# Aggregate by Name column
df_aggregated = df.groupby("Name").sum().reset_index()
# Sort by Day7RunHour column in descending order
df_aggregated = df_aggregated.sort_values(by="Day7RunHour", ascending=False)
# for index, row in df_aggregated.iterrows():
# print(row["Name"], row["Day7RunHour"])
df_aggregated.to_excel("data/cbec-robot-info/robot-name-temu-clear-manual.xlsx", index=False)