-
Notifications
You must be signed in to change notification settings - Fork 0
/
prob5.py
61 lines (57 loc) · 1.63 KB
/
prob5.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
import pandas as pd
def prob5(ans):
data=pd.read_excel("E:\\python\\project\\App-data.xlsx")
date=data["Last Updated"].tolist()
installs = data["Installs"].tolist()
categories=set()
for category in data["Category"]:
categories.add(category)
if ans in categories:
f=1
else:
return 1,2
for i in range(len(installs)):
if installs[i]=="1,000+":
installs[i]=0.1
continue
if installs[i]=="5,000+":
installs[i]=0.5
continue
if installs[i]=="10,000+":
installs[i]=1
continue
if installs[i]=="50,000+":
installs[i]=5
continue
if installs[i]=="100,000+":
installs[i]=10
continue
if installs[i]=="500,000+":
installs[i]=50
continue
if installs[i]=="1,000,000+":
installs[i]=100
continue
if installs[i]=="5,000,000+":
installs[i]=500
continue
if installs[i]=="50,000,000+":
installs[i]=5000
continue
if installs[i]=="10,000,000+":
installs[i]=1000
continue
else:
installs[i]=0.0
ser1=pd.Series(installs)
data["installs"]=ser1
del data["Installs"]
grp1=data.groupby(["Category"])
indices=grp1.groups[ans].tolist()
y=list()
x=list()
for i in indices:
y.append(data['installs'][i])
x.append(pd.to_datetime(data["Last Updated"][i]))
x.sort()
return x,y