<jupyter_start><jupyter_text>--- Q. users에서 20대 중반 이상의 유저들만 보려면? (즉, 24세 이하를 제외한다면)<jupyter_code># A0 =
# YOUR CODE HERE
raise NotImplementedError()<jupyter_output><empty_output><jupyter_text>```        gender  age  occupation    zipuser_id                               2            M   56          16  700723            M   25          15  551174            M   45           7  024605            M   25          20  554556            F   50           9  55117```<jupyter_code>assert len(A0) == 4715
assert (A0.age > 24).all()<jupyter_output><empty_output><jupyter_text>Q. users에서 20대 중반 이상의 여자들만 보고 싶다면?<jupyter_code># A1 = 
# YOUR CODE HERE
raise NotImplementedError()<jupyter_output><empty_output><jupyter_text>```        gender  age  occupation    zipuser_id                               6            F   50           9  5511710           F   35           1  9537011           F   25           1  0409316           F   35           0  2067024           F   25           7  10023```<jupyter_code>assert len(A1) == 1333
assert (A1.gender == 'F').all()
assert (A1.age > 24).all()<jupyter_output><empty_output><jupyter_text>Q. ratings에서 1번 영화를 본 유저들과 그들이 준 rating 점수를 보고 싶다면?<jupyter_code># A2 = 
# YOUR CODE HERE
raise NotImplementedError()<jupyter_output><empty_output><jupyter_text>```        user  ratingid                  2787_1  2787       52788_1  2788       52792_1  2792       32796_1  2796       32799_1  2799       5```<jupyter_code>assert len(A2) == 15
assert 'user' in A2.columns and 'rating' in A2.columns and len(A2.columns) == 2
assert all(A2.index.str[-1] == '1')<jupyter_output><empty_output><jupyter_text>Q. movies에서 movie_id가 1인 영화만 하나만 보려면?<jupyter_code># A3 = 
# YOUR CODE HERE
raise NotImplementedError()<jupyter_output><empty_output><jupyter_text>```title                Toy Story (1995)genres    Animation|Children's|ComedyName: 1, dtype: object```<jupyter_code>assert A3.name == 1
assert A3.genres == "Animation|Children's|Comedy"
assert len(A3.index) == 2<jupyter_output><empty_output><jupyter_text>Q. movies에서 movie_id가 1인 영화의 title을 보려면?<jupyter_code># A4 = 
# YOUR CODE HERE
raise NotImplementedError()
assert all(movies[lambda x: x.title == A4].index == 1)<jupyter_output><empty_output><jupyter_text>Q. ratings에서 1점을 받은 movie만 뽑아 보려면?<jupyter_code># A5 = 
# YOUR CODE HERE
raise NotImplementedError()<jupyter_output><empty_output><jupyter_text>```           user  movie  ratingid                            2783_208   2783    208       12784_3248  2784   3248       12784_3566  2784   3566       12785_2396  2785   2396       12786_637   2786    637       1```<jupyter_code>assert len(A5) == 305
assert all(A5.rating == 1)<jupyter_output><empty_output><jupyter_text>Q. ratings에서 3934번 유저의 평점들만 보려면?<jupyter_code># A6 = 
# YOUR CODE HERE
raise NotImplementedError()<jupyter_output><empty_output><jupyter_text>```id2783_1253    52783_589     52783_1270    42783_1274    42783_741     5Name: rating, dtype: int64```<jupyter_code>assert len(A6) == 10
assert A6.mean() == 2.1<jupyter_output><empty_output><jupyter_text>Q. movies에서 Toy Story (1995), Heat (1995), Copycat (1995)의 장르만 보려면?<jupyter_code># A7 =
# YOUR CODE HERE
raise NotImplementedError()<jupyter_output><empty_output><jupyter_text>```movie_id1     Animation|Children's|Comedy6           Action|Crime|Thriller22           Crime|Drama|ThrillerName: genres, dtype: object```<jupyter_code>assert len(A7) == 3
assert A7.name == 'genres'
assert A7.iloc[0] == "Animation|Children's|Comedy"
assert A7.str.contains('Thriller').sum() == 2<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.10954660658969305, 'fraction_numerical': 0.103914390312588, 'mean_word_length': 3.031782065834279, 'pattern_counts': {'":': 0, '<': 61, '<?xml version=': 0, '>': 63, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 4, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '15', 'dir': 'jupyter-structured-clean-dedup', 'id': '220310', 'license': 'Apache-2.0', 'n_tokens_mistral': 1626, 'n_tokens_neox': 1471, 'n_words': 278, 'path': 'prerequisites4 - pandas -  quiz - indexing.ipynb', 'repo_name': 'parksurk/da_structured-data', 'size': '3551'}