import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
#df = pd.read_excel(‘新闻.xls‘)
df = pd.read_excel(‘新闻.xls‘,sheet_name=‘Sheet2‘)
dfm = df.authorName
dfx=df.pinglun
dfy=df.webHits
def xi(x):
arry=[]
for i in dfm :
if i == x:
arry.append(True)
else:
arry.append(False)
return arry
Ndfx=dfx[xi(‘Destiny Adams‘)]
Ndfy=dfy[xi(‘Destiny Adams‘)]
plt.title(‘Destiny Adams‘)
plt.scatter(Ndfx,Ndfy)
plt.show()
原文:https://www.cnblogs.com/big-tree/p/13326801.html