python数据框操作

Question

请问我该怎么筛选出热度大于1万的游戏

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from pylab import mpl
plt.rcParams['font.sans-serif'] = ['FangSong']
df=pd.read_excel('datatable.xlsx').fillna(0)
y = []

for ele in df["热度"]:
    if "亿" in ele:
        y.append(eval(ele.replace("亿",""))*10000)
    elif "万" in ele:
        y.append(eval(ele.replace("万","")))
    else:
        y.append(eval(ele)/10000)
company = []

for c in df["游戏"]:
    company.append(c)
plt.figure(figsize=(30,30))
plt.barh(range(len(y)), y, tick_label=company)
plt.savefig("./hot.png", dpi=100)
plt.show()

Answer 1

按行遍历下，判断热度大于1w在c和company在添加

 
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from pylab import mpl
plt.rcParams['font.sans-serif'] = ['FangSong']
df=pd.read_excel('datatable.xlsx').fillna(0)
y = []
company = []

for row in df.index:
    ele=df.loc[row]['热度']
    if "亿" in ele:
        v=eval(ele.replace("亿",""))*10000
    elif "万" in ele:
        v=eval(ele.replace("万",""))
    else:
        v=eval(ele)/10000
    if v>1:
        y.append(v)
        company.append(df.loc[row]['游戏'])

plt.figure(figsize=(30,30))
plt.barh(range(len(y)), y, tick_label=company)
plt.savefig("./hot.png", dpi=100)
plt.show()