fpath = "datas/beijing_tianqi/beijing_tianqi_2018.csv"
df = pd.read_csv(fpath)
df.loc[:,"bWendu"] = df["bWendu"].str.replace("℃","").astype('int32')
df.loc[:,"yWendu"] = df["yWendu"].str.replace("℃","").astype('int32')
df.loc[:,"wencha"] = df["bWendu"] - df["yWendu"]
print(df.head())
def get_wendu_type(x):
if x["bWendu"] > 33:
return '高温'
if x["yWendu"] < -10:
return '低温'
return '常温'
df.loc[:,"wendu_type"] = df.apply(get_wendu_type,axis=1)
print(df["wendu_type"].value_counts())
print(df.head())
print(df.assign(
yWendu_huashi=lambda x: x["yWendu"] * 9 / 5 + 32,
bWendu_huashi=lambda x: x["bWendu"] * 9 / 5 + 32
))
df['wencha_type'] = ''
df.loc[df["bWendu"]-df["yWendu"]>10,"wencha_type"] = '温差大'
df.loc[df["bWendu"]-df["yWendu"]<=10,"wencha_type"] = '温差正常'
print(df["wencha_type"].value_counts())
转载请注明原文地址:https://blackberry.8miu.com/read-29701.html