当前位置：网站首页>Dataframe sorting: datetime format splitting; Delete a specific line; Group integration.

Dataframe sorting: datetime format splitting; Delete a specific line; Group integration.

2022-07-26 03:06:00 【Ten at eight】

Import CSV Format data , And separate the month, year and day .

take csv Import format data as dataframe Format .
also , take date columne Split on the day of .
First, make sure date columne The format in is datetime Format .

import pandas as pd
#pd.set_option('display.max_rows', None) 

df = pd.read_csv(r"D:\xxx.csv",parse_dates=["date"])

df["year"] = df.date.apply(lambda x:x.year)
df["month"] = df.date.apply(lambda x:x.month)
df["day"] = df.date.apply(lambda x:x.day)

Delete specific lines

Put one in each line columne If 0, Then delete the line .

df=df.drop(df[df["xxx"] == 0].index)

Group by year and month

Use groupby function . And for size columne In sum .

month_size = df["size"].groupby([df["year"],df["month"]]).sum()
day_size = df["size"].groupby([df["year"],df["month"],df["day"]]).sum()
原网站

版权声明
本文为[Ten at eight]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/207/202207260303266930.html

边栏推荐

猜你喜欢

随机推荐