import pandas as pd
cat_df = pd.read_csv("catNames2.csv")
cnt = cat_df[cat_df["Count_AnimalName"] > 800]
sort = cnt.sort_values(by="Count_AnimalName",ascending=False)
print("使用次数超过800的猫的名字:")
print(sort)
sort2 = cat_df.sort_values(by="Count_AnimalName", ascending=False)
max_cnt = sort2[:1]
print("使用次数最高的名字:")
print(max_cnt)
import pandas as pd
wly_data = pd.read_excel("五粮液2020.xlsx", index_col=0)
print(wly_data.info())
print("每一天各指标的差异值:")
print(wly_data.diff())
print("pre_close 的增长率:")
print(wly_data["pre_close"].pct_change())
wly_data["pct_change"] = wly_data["pre_close"].pct_change()
print(wly_data)
wly_data.fillna(value = 0, inplace = True)
print(wly_data)
print(wly_data["pre_close"].corr(wly_data["pct_change"]))
print("修改后的pct_change为:")
func = lambda x: "%.2f%%" % (x * 100)
wly_data["pct_change"] = wly_data["pct_change"].apply(func)
print(wly_data["pct_change"])