# Start writing code here...
import pandas as pd
data = pd.read_csv("parkingpay.net_ssl.csv"," ")
data.head()
def filter_url(x):
if isinstance(x, str):
return "weixin" in x
else:
return False
def filter_ua(x):
if isinstance(x, str):
return "MSIE 9.0" in x
else:
return False
new_data=data[["IP","UA","URL"]]
weixin_data=new_data[new_data["URL"].apply(filter_url) & new_data["UA"].apply(filter_ua)]
ips=weixin_data.groupby("IP")["URL"].count()
pd_ips=ips.to_frame()
pd_ips=pd_ips.reset_index()
pd_ips.columns=["IP","Count"]
# pd_ips.to_csv("ip.csv",index=False)
pd_ips.sort_values(by="Count",ascending=False).head(50)