-
Notifications
You must be signed in to change notification settings - Fork 5
/
indexing_selecting_assigning.py
executable file
·130 lines (73 loc) · 2.79 KB
/
indexing_selecting_assigning.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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
import pandas as pd
import seaborn as sns
reviews = pd.read_csv("../input/wine-reviews/winemag-data-130k-v2.csv", index_col=0)
def check_q1(ans):
expected = reviews.description
return ans.equals(expected)
def answer_q1():
print("""reviews.description""")
def check_q2(ans):
expected = reviews.description[0]
return ans == expected
def answer_q2():
print("""reviews.description[0]""")
def check_q3(ans):
expected = reviews.iloc[0]
return ans.equals(expected)
def answer_q3():
print("""reviews.iloc[0]""")
def check_q4(ans):
expected = reviews.iloc[0:10, 1]
return ans.equals(expected)
def answer_q4():
print("""reviews.iloc[0:10, 1]""")
def check_q5(ans):
expected = reviews.iloc[[1, 2, 3, 5, 8]]
return ans.equals(expected)
def answer_q5():
print("""reviews.iloc[[1, 2, 3, 5, 8]]""")
def check_q6(ans):
expected = reviews.loc[[0, 1, 10, 100], ['country', 'province', 'region_1', 'region_2']]
return ans.equals(expected)
def answer_q6():
print("""reviews.loc[[0, 1, 10, 100], ['country', 'province', 'region_1', 'region_2']]""")
def check_q7(ans):
expected = reviews.loc[0:100, ['country', 'variety']]
return ans.equals(expected)
def answer_q7():
print("""reviews.loc[0:100, ['country', 'variety']]""")
def check_q8(ans):
expected = reviews.loc[reviews.country == 'Italy']
return ans.equals(expected)
def answer_q8():
print("""reviews.loc[reviews.country == 'Italy']""")
def check_q9(ans):
expected = reviews.loc[reviews.region_2.notnull()]
return ans.head().equals(expected.head())
def answer_q9():
print("""reviews.loc[reviews.region_2.notnull()]""")
def check_q10(ans):
expected = reviews.points
return sns.countplot(ans) if ans.head().equals(expected.head()) else False
def answer_q10():
print("""reviews.points""")
def check_q11(ans):
expected = reviews.loc[:1000, 'points']
return sns.countplot(ans) if ans.head().equals(expected.head()) else False
def answer_q11():
print("""reviews.loc[:1000, 'points']""")
def check_q12(ans):
expected = reviews.iloc[-1000:, 3]
return sns.countplot(ans) if ans.head().equals(expected.head()) else False
def answer_q12():
print("""reviews.iloc[-1000:, 3]""")
def check_q13(ans):
expected = reviews[reviews.country == "Italy"].points
return sns.countplot(ans) if ans.head().equals(expected.head()) else False
def answer_q13():
print("""reviews[reviews.country == "Italy"].points""")
def check_q14(ans):
expected = reviews[reviews.country.isin(["Italy", "France"]) & (reviews.points >= 90)].country
return sns.countplot(ans) if ans.head().equals(expected.head()) else False
def answer_q14():
print("""reviews[reviews.country.isin(["Italy", "France"]) & (reviews.points >= 90)].country""")