python数据框操作

请问我该怎么筛选出热度大于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()

按行遍历下，判断热度大于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()

代码如下，你试试看行不

# coding:utf8
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, name in zip(df["热度"],df["游戏"]):
    if "亿" in ele:
        y.append([eval(ele.replace("亿",""))*10000,name])
    elif "万" in ele:
        y.append([eval(ele.replace("万","")),name])
    else:
        y.append([eval(ele)/10000,name])

num = []
com = []

for i in y:
    if i[0] > 1:
        num.append(i[0])
        com.append(i[1])
        

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

```python

```

您好，我是有问必答小助手，您的问题已经有小伙伴帮您解答，感谢您对有问必答的支持与关注！
PS：问答VIP年卡 【限时加赠：IT技术图书免费领】，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632