| CARVIEW |
?mpandas??????n?f?[?^?Z?b?g?̑O?????????Ă݂悤?FPython?f?[?^????????
?^?C?^?j?b?N?f?[?^?Z?b?g???g???āA?????l?̈??????A?s?v?ȗ?̍폜?A?J?e?S???J???f?[?^?̃G???R?[?f?B???O?ȂǁA?O?????̎d???????Ă????܂??傤?B
???̋L???͉??????ł??B????o?^?i?????j????ƑS?Ă????????????܂??B
?{?V???[?Y?Ɩ{?A?ڂɂ???
?@?{?V???[?Y?uPython?f?[?^????????v?́APython?̊?b???}?X?^?[?????l??ΏۂɈȉ??̂悤?ȁAPython???g???ăf?[?^?????????悤?Ƃ????Ƃ??ɕ֗??Ɏg????c?[????C?u?????A?t???[?????[?N?̎g?????̊?b???????????̂ł??B
- NumPy?i?uNumPy??????v?̖ڎ??????????j
- pandas?i?{?A?ځj
- Matplotlib
?@?Ȃ??A?{?A?ڂł͈ȉ??̃o?[?W???????g?p???Ă??܂??B
- Python 3.12
- pandas 2.2.1
?@?O???̓^?C?^?j?b?N?f?[?^?Z?b?g??pandas?ɓǂݍ???ŁA???̊T?v?ׂ???A???ʂƐ??????A?܂??͗??q?N???X?Ɛ??????Ɋ֘A?????邩?ǂ????Ȃǂ????Ă݂܂????B???̂Ƃ??A?????l???܂ޗ?i'Cabin'??j?Ȃǂɂ??Ă͂??̂܂܂ɂ??Ă??܂????B????͂??̂悤?ȗ???ǂ?????????悢?̂???A?@?B?I?ȏ??????ȒP?ɂȂ?悤?ɐ??ʂ◷?q?N???X?𐔒l?f?[?^?ɕϊ???????@?Ȃǂ????Ă????܂??B???̂悤?ȍ?Ƃ̂??Ƃ??u?O?????v?ƌĂт܂??B?O?????̓f?[?^?Z?b?g???@?B?w?K??f?B?[?v???[?j???O?œK?Ɏ?舵????悤?ɂ??邽?߂̏d?v?ȃX?e?b?v?ł????A????͂??̗??K?̂悤?Ȃ??̂ł??B
?@???|????O?ɁA?^?C?^?j?b?N?f?[?^?Z?b?g?̓??e??DataFrame?I?u?W?F?N?g?ɓǂݍ???ł????܂??傤?i?^?C?^?j?b?N?f?[?^?Z?b?g?͑O?l??pandas??GitHub???|?W?g??????_?E?????[?h???܂????j?B
import pandas as pd
df = pd.read_csv('titanic.csv')
?????l???܂ޗ?
?@?ȉ??̓^?C?^?j?b?N?f?[?^?Z?b?g?̓??e??????????ƕ\?????????̂ł??B
?@'Age'???'Cabin'??ɂ́uNaN?v?ƕ\??????Ă???ӏ??????邱?Ƃ??m?F?ł??܂??B?????őO??????܂??????Ainfo???\?b?h???Ăяo???āA?e??̏?Ԃ??m?F???Ă݂??̂??ȉ??ł??B
?????l???܂ޗ??'Age'???'Cabin'??A'Embarked'???3???@?O????q?ׂ܂??????A???̃f?[?^?Z?b?g?ɂ?891?s?̃f?[?^??????A?e?s??12?̗?ō\??????Ă??܂??B?????āAinfo???\?b?h?̏o?͌??ʂ?????ƁA'Age'??i?N??j?ɂ͌??????Ă??Ȃ??f?[?^??714?A'Cabin'??i?q???ԍ??j?ɂ͌??????Ă??Ȃ??f?[?^??204?A'Embarked'??i??D?l?j?ɂ͌??????Ă??Ȃ??f?[?^??889???邱?Ƃ???????܂??B
?@?????̂????A'Cabin'??Ɋւ??Ă͌??????Ă???f?[?^?????߂??邱?Ƃ???A????͑f???ɂ??̗?͍폜???Ă??܂????Ƃɂ??܂??傤?i??q?j?B?c??2?̗?ɂ??Ă͉??Ƃ??Ȃ?Ȃ??????????l???????Ǝv???܂??B
'Embarked'??
?@?܂??͌????l?????Ȃ?'Embarked'??ɂ??čl???Ă݂܂??傤?B'Embarked'??̒l?͏?D?l??\?????̂?'S'?Ȃ?T?E?T???v?g???A'C'?Ȃ?V?F???u?[???A'Q'?̓N?C?[???Y?^?E???ł??邱?Ƃ??????Ă??܂??B?????ŁA?O????ڂ????????????Ɏg???Ă??܂???groupby???\?b?h???g???āA???̗?̒l???ƂɃf?[?^???܂Ƃ߂Ă݂܂??B?ȉ??͍???g?p????͈͂ł?groupby???\?b?h?̎g???????܂Ƃ߂????̂ł??B
pandas.DataFrame.groupby???\?b?h
pandas.DataFrame.groupby(by=None)
?@DataFrame?I?u?W?F?N?g???w?肵????̒l???ƂɃO???[?v?ɂ܂Ƃ߂?Bby?p?????[?^?[?ɕ????̗?v?f?Ƃ??????X?g??n???ƁA?????̗??ƂɃO???[?v???ו????????Bgroupby???\?b?h?̖߂?l??DataFrameGroupBy?I?u?W?F?N?g?ł???A???̃I?u?W?F?N?g?ɂ???ɏW?v?Ȃǂ??s?????\?b?h???Ăяo?????ƂŃO???[?v???Ƃ̏????擾?ł???i?ڍׂ?pandas?̃h?L???????g?upandas.DataFrame.groupby?v?uGroup by: split-apply-combine?v?Ȃǂ??Q?Ƃ̂??Ɓj?B
?@?????ł?'Embarked'??̒l?ŃO???[?v???쐬??????A????size???\?b?h???Ăяo???āA??D?n?̕??z???ǂ??Ȃ??Ă??邩???m?F???Ă݂܂??傤?B
df.groupby('Embarked').size()
?@???s???????ʂ??ȉ??Ɏ????܂??B
?T?E?T???v?g???????D?????l????ԑ??????Ƃ????????@?T?E?T???v?g???i'S'?j?????D?????l??644?l?A?V?F???u?[???i'C'?j?????D?????l??168?l?A?N?C?[???Y?^?E???i'Q'?j?????D?????l??77?l?ł??邱?Ƃ???????܂????B???̗?Ō??????Ă???̂?2?̃f?[?^?????ł??B????̕??@?͍l?????܂??B?Ⴆ?A???????Ă???s???폜???Ă??܂??Ƃ??B???邢?́A3?̏?D?n?̂????ꂩ?Ńf?[?^??⊮????̂?????ł??傤?i???ς????킯?ɂ͂????܂????ˁB??ŏo?Ă??܂????A???̂悤?ȃf?[?^?̂??Ƃ??u?J?e?S???J???f?[?^?v?Ƃ????܂??j?B?????ł͍ŕp?l?ł???'S'???g???ăf?[?^??⊮???邱?Ƃɂ??܂??B
?@???????Ă???f?[?^??⊮????ɂ?DataFrame?I?u?W?F?N?g?i?܂???Series?I?u?W?F?N?g?j??fillna???\?b?h???g?p???܂??B
pandas.DataFrame.fillna???\?b?h
pandas.DataFrame.fillna(value=None)
pandas.Series.fillna(value=None)
?@DataFrame?I?u?W?F?N?g?܂???Series?I?u?W?F?N?g?̌????l??⊮????Bvalue?p?????[?^?[?ɂ͕⊮?Ɏg?p????l?܂??͎????Ȃǂ??w??ł???B?S?Ẵp?????[?^?[?ɂ??Ă?pandas?̃h?L???????g?upandas.DataFrame.fillna?v?upandas.Series.fillna?v???Q?Ƃ̂??ƁB
?@????'Embarked'??̍ŕp?l??'S'?ł??邱?Ƃ͕??????Ă??܂????A?????ł?'Embarked'??ɑ???mode???\?b?h???Ăяo???āA?ŕp?l?imode?j???擾????Ƃ??납?????Ă݂܂??傤?B
mode = df['Embarked'].mode()
print(mode)
print(type(mode))
print(mode[0])
?@???s???ʂ͎??̂悤?ɂȂ?܂????B
?ŕp?l?????߂??@?udf['Embarked'].mode()?v?Ƃ??邱?ƂŁA?????ł?'Embarked'??̍ŕp?l???擾???Ă??܂??B???????A???̖߂?l??Series?I?u?W?F?N?g?ɂȂ??Ă???̂ŁA?C???f?b?N?X??0???w?肵?āA???̐擪?v?f???擾????悢?ł??傤?B
?@?ł́Afillna???\?b?h?Ō????l???ŕp?l?ŕ⊮???܂??傤?B?????ł?DataFrame?I?u?W?F?N?g??fillna???\?b?h???Ăяo???Ă݂܂??B
df2 = df.fillna({'Embarked': mode[0]})
?@?????ł͉????????s???Ă???蒼????悤?ɕϐ?df2?Ɍ????l??⊮??????̃I?u?W?F?N?g???????Ă??܂??i???Ȃ???Ό??̕ϐ?df?ɑ?????Ă??悢?ł??傤?j?Bvalue?p?????[?^?[?ɂ́u{'Embarked': mode[0]}?v?Ǝw??????Ă??܂??B????ɂ??A'Embarked'??̌????l??mode[0]?̒l?ŕ⊮???邱?ƂɂȂ?܂??B???邢?͎??̂悤?ȃR?[?h???????܂??B
df2 = df.copy()
df2['Embarked'] = df2['Embarked'].fillna(mode[0])
?@????́i??͂莸?s?????Ƃ??ɂ?蒼????悤?Ɂj?ϐ?df2??df?̃R?s?[???????A???̌?Łudf2['Embarked'].fillna(mode[0])?v?Ƃ???Series?I?u?W?F?N?g?̌????l??⊮???A???̌??ʂ?df2['Embarked']?iSeries?I?u?W?F?N?g?j?ɑ?????āA?V?????l?ɒu????????R?[?h?ł??B?ǂ??炪?悢???͍D?݂ł͂Ȃ??ł??傤???B???????A?udf.fillna('S')?v?̂悤?ɂ??Ă??܂??ƁA????DataFrame?I?u?W?F?N?g?̑S?Ă̌????l??'S'?ŕ⊮????Ă??܂????Ƃɂ͒??ӂ??Ă????????B???????A?S?Ă̌????l???܂Ƃ߂ĕ⊮?ł???悤?Ȓl??????A????ł??\???܂??A?????ł͂Ȃ????Ƃ̕????????Ƒ????ł??傤?B
?@??????info???\?b?h???Ăяo???Ă݂܂??傤?B
?????l???⊮???ꂽ?̂?'Embarked'??̔??l?̐???891?ɂȂ????@?u11 Embarked 891 non-null object ?v?Ƃ??邱?Ƃ???A?⊮???ꂽ?悤?ł??ˁB?Ȃ??A????df?I?u?W?F?N?g??'Embarked'??Ō????l?????????s?͎??̂悤?ɂ??Ē??ׂ??܂??B
nanrow = df[df['Embarked'].isnull()]
nanrow
?@????nanrow?I?u?W?F?N?g??index?l??df2?I?u?W?F?N?g??loc?????Ɏw?肵?Ă??A's'???⊮???ꂽ???ǂ??????m?F?ł??܂??B
df2.loc[nanrow.index]
?@???s???ʂ??ȉ??Ɏ????܂??B
'Age'??
?@'Age'??͂??????N????i?[???Ă????ł??B??قnj????Ƃ??ɂ͌??????Ă??Ȃ??f?[?^??714?i???????Ă???f?[?^??177?j????܂????B'Cabin'??̂悤?Ɍ??????Ă???f?[?^?????܂?ɂ??????Ƃ??????Ȃ??̂ŁA????͉??Ƃ??⊮???????̂ł????A?ǂ?????悢?ł??傤???B'Embarked'???3?̏?D?n?̒??ōŕp?l?ƂȂ?l??I?т܂????B?????ł͒P?p?ɎZ?p???ς?????????̂ŕ⊮???邱?Ƃɂ??܂??B
?@???????A?????I?ɂ́A?܂???'Age'??̃q?X?g?O???????쐬????Ȃǂ??āA?f?[?^?̕??z???m?F???邱?Ƃ??d?v?ł??B???z?I?ɂ͒????ɎR?????鐳?K???z?̌`???]?܂????ł??B????͐}?????܂??A'Age'??̃q?X?g?O?????ł͍??ɕ??????z???????A??N?w?????????Ƃ???????܂??B???̂悤?ȏꍇ?ɂ́A?u???ϒl?v???g???????u?????l?v?ŕ⊮????????A?????ۂ̃f?[?^?f???????ʂɂȂ?\?????????ł??B???ϒl?ŕ⊮????ƁA?ɒ[?Ȓl?Ɉ????????ăf?[?^?S?̂̃o?????X??????A???͂?@?B?w?K?̌??ʂ??䂪?ތ????ƂȂ邱?Ƃ?????̂Œ??ӂ??܂??傤?B
?@?܂??A?????l?╽?ϒl?ȊO?ɂ??A?????l??⊮??????@?͊???l?????܂??B?Ⴆ?A??A???͂Ȃǂ̃A???S???Y????p???ĔN??𐄒肷?邱?Ƃ??\?ł??B????ɂ??A??萸?x?̍????????l?̕⊮?????҂ł??܂??B
?@?Ƃ͂????A????͓???A?ڂŌ????l?????????ł?????A?܂??͍ł??V???v???ȁu???ϔN??ŕ⊮??????@?v?̗Ⴞ???????????Ƃɂ??܂??傤?B???ς͎??̂悤?ɂ??Čv?Z?ł??܂??B
mean_age = df['Age'].mean()
print(mean_age) # 29.69911764705882
?@???ϔN????v?Z?ł?????A??͐?قǂƓ??l?ł??i'Embarked'??̌????l??⊮???????DataFrame?I?u?W?F?N?g??df2?ɑ?????Ă???̂ŁA??????g???Ă???_?ɂ͒??ӂ??Ă????????j?B
df3 = df2.fillna({'Age': mean_age})
#df3 = df2.copy()
#df3['Age'] = df3['Age'].fillna(mean_age)
df3.info()
?@??L?R?[?h?̎??s???ʂ??ȉ??Ɏ????܂??B
?⊮?ł????@??͌????l??????????'Cabin'??ƁA???̌?͎g?p???Ȃ??ł??낤??i'PassengerId'???'Name'??Ȃǁj???폜????悢?ł??傤?B
??̍폜
?@?????l???܂ޗ???폜????ɂ?pandas.DataFrame.dropna???\?b?h???g?p???܂??B????ɂ??Ă͖{?A?ڂ̑?9??u?????l?Ƃ??̏????v?̒??ŏЉ?܂????B
?@?????ł͍폜???@???w?肷??how?p?????[?^?[??'any'???Aaxis?p?????[?^?[??1???w?肵?āA?????l???܂ޗ??S?č폜????悤?ɂ??܂??i?????l??⊮???????DataFrame?I?u?W?F?N?g?͕ϐ?df3?ɑ??????Ă???_?ɒ??Ӂj?B
df4 = df3.dropna(how='any', axis=1)
df4.info()
?@???̃R?[?h?????s????Ǝ??̂悤?ɂȂ?܂??B
'Cabin'?폜????A891?s?~11??̃f?[?^?Z?b?g?ɂȂ????@????̗???폜????ɂ͖{?A?ڂ̑?6??uDataFrame?ɑ??čs????lj???????폜?????肵?Ă݂悤?v?ŏЉ??pandas.DataFrame.drop???\?b?h???g?p???܂??B
?@?????ł͈ȉ??̗???폜???邱?Ƃɂ??܂????B
- 'PassengerId'??F?e?s??0?n?܂?ŐU??????????ID?Ȃ̂Ő????ɂ͊W?Ȃ?
- 'Name'??F???O?Ɛ????ɊW?͂Ȃ?????
- 'Ticket'??F?`?P?b?g?ԍ??Ɛ????ɊW?͂Ȃ?????
?@?{???́u?W?Ȃ??????v?Ƃ????????ň??Ղɍ폜????̂͐??????Ȃ??̂ł??傤???i?^?̋??????O?????邩??????܂??A?`?P?b?g?ԍ????悭????????A?????Ƃ̉??炩?̊W???????邩??????܂???j?A?????ł̓f?[?^?????H??????K?Ƃ??Ă????3?̗???폜???邱?Ƃɂ??܂??B
?@?폜??????drop???\?b?h??columns?p?????[?^?[??3?̗?̗x?????w?肵?܂??i???邢??labels?p?????[?^?[?ɂ??????w?肵?āAaxis?p?????[?^?[??1???w??j?B
df5 = df4.drop(columns=['PassengerId', 'Name', 'Ticket'])
#df5 = df4.drop(labels=['PassengerId', 'Name', 'Ticket'], axis=1)
df5.info()
?@????ɂ?莟?̂悤??3?̗폜????܂??B
3?̗폜????A891?s?~8??̃f?[?^?Z?b?g???ł????@?????ŏ?̉摜?́uDtype??v?ɒ??ڂ??Ă????????B'Sex'???'Embarked'??????iobject?^?j?ɂȂ??Ă??邱?Ƃ???????܂??B?O????q?ׂ܂??????A?v???O?????ŋ@?B?I?Ƀf?[?^?Z?b?g?????????????Ƃ????ꍇ?A??????ł͂Ȃ??A???l?f?[?^?̕????֗??ł??B?????????f?[?^?𐔒l?ɕϊ?????ɂ͊???̕??@??????܂??B
?G???R?[?f?B???O
?@???ʁi'Sex'??j???D?n?i'Embarked'??j?̂悤?ȃf?[?^?̂??Ƃ??J?e?S???J???f?[?^?ȂǂƌĂԂ??Ƃ?????܂??B?j???Ə????A?T?E?T???v?g???ƃV?F???u?[???Ȃǂ͂???炪?????܂ł????炩?̃J?e?S???[?i?O???[?v?j?????????̂ł????āA???ς????????A??????t??????͂ł??܂???B???????A?j????0?A??????1?̂悤?ɐ??l?f?[?^?Ƃ??Ď?舵?????Ƃ??\?ł????A1?̕????G?????Ƃ??A2?̕????傫???Ƃ???ʂ?????̂ł͂???܂???B???̂悤?ȃf?[?^?́u???`?ړx?v?????Ƃ??????Ƃ?????܂??i???`?Ƃ͂???f?[?^?ƕʂ̃f?[?^????ʂ??閼?O???炢?̗?????????悢?ł??傤?j?B
?@????ɑ??āA'Pclass'??͗??q?N???X?𐔒l?f?[?^?ł??B???̒l??1?Ȃ?1???A2?Ȃ?2???A3?Ȃ?3???Ƃ??????q?N???X??\???A?????W?i?召?W?j???????܂??B???????A?????̒l?ƒl?i?Ⴆ?A1??2?j?????Ԋu?ɕ????̂Ƃ????킯?ł͂???܂???B???̂悤?Ȏ?ނ̃f?[?^?́u?????ړx?v?????Ƃ??????Ƃ?????܂??B?????ړx?????f?[?^???܂??J?e?S???J???f?[?^?̈??ł??B???`?ړx?Ə????ړx?????f?[?^?̂??Ƃ??u?萫?I?ȃf?[?^?v?ƌĂԂ??Ƃ?????܂??B'Pclass'???1?A2?A3?Ƃ????l??'S'?A'A'?A'B'?Ƃ?????????ŕ\???\?ȃf?[?^?𐔒l?ɕϊ????????m???Ƃ??l?????܂??ˁB
?@???q?ׂ??萫?I?ȃf?[?^?ƑɂȂ?̂??u??ʓI?ȃf?[?^?v?ł??B????͓ǂ?Ŏ??̂??Ƃ??A?ʂ?\?????̂ł??B?Ⴆ?A?N??i'Age'??j??^???i'Fare'??j?̒l?͗ʂ?\???Ă???̂Œ?ʓI?ȃf?[?^?ł??B??ʓI?ȃf?[?^??2??ނɕ??????܂??B1?́u?Ԋu?ړx?v???????̂ŁA????1?́u?䗦?ړx?v???????̂ł??B???̈Ⴂ?͔䗦?ړx?????f?[?^?ɂ͌??_0?Ƃ???????_?i?l?j?????݂??A?䗦?̂悤?ȊW???????Ƃł??i?Ԋu?ړx?ɂ͂????????????͂???܂???j?B
?@?Ⴆ?A?ێ?0?x?͕X?_?i?????Ìł??ĕX?ɕς?鉷?x?j?Ƃ??ĔC?ӂɒ?߂????̂ŁA??ΓI?Ȍ??_0?Ƃ͂????܂???i???āA????ȏ?Ⴂ???x?͂Ȃ??A???q?̉^???G?l???M?[??0?ɂȂ??Η?x?͐?ΓI?Ȍ??_0?Ƃ????Ă??悢????????܂???B?܂?A??Ή??x?͔䗦?ړx?????Ƃ?????ł??傤?j?B????ɐێ?20?x?͐ێ?10?x?̔{?̉??x?ł͂Ȃ??̂Ŕ䗦?????߂邱?Ƃ͂ł??܂???B????Đێ????x?͊Ԋu?ړx???????܂????A?䗦?ړx?ł͂Ȃ??Ƃ?????ł??傤?B????ɑ??āA?̏d?͖??m?Ȍ??_0?i?̏d0kg?j??????A60kg?̑̏d??1.5?{??90kg?̂悤?Ȕ??W???????܂??B????āA?̏d?͔䗦?ړx?????Ƃ?????ł??傤?B
?@????b?́u?Љ?l1?N??????w?ԁA?₳?????f?[?^?????v??ǂ?ł????????Ƃ??āA?????ł͍ŏ??ɏo?Ă????J?e?S???J???f?[?^??'Sex'???'Embarked'??𐔒l?f?[?^?ɕϊ???????@???Љ?܂??傤?B???̂悤?ȕϊ??̂??Ƃ??G???R?[?f?B???O?ƌĂԂ??Ƃ?????܂??B
?@?J?e?S???J???f?[?^?̃G???R?[?f?B???O?ɂ͊???̎?ނ?????܂??B??\?I?Ȃ??̂??????܂??傤?B
- Label?G???R?[?f?B???O
- Ordinal?G???R?[?f?B???O
- One-Hot?G???R?[?f?B???O
?@Label?G???R?[?f?B???O?̓J?e?S???J???f?[?^??P???ɐ??l?ɒu??????????̂ł??B?Ⴆ?A'Sex'???'male'??0?ɁA'female'??1?ɃG???R?[?f?B???O????Ƃ????????Ƃ??l?????܂??B????͒P???ł悢?̂ł????A?G???R?[?f?B???O??̐??l???????̈Ӑ}???Ă??Ȃ??Ӗ????????Ă??܂??\????????_?ɂ͒??ӂ??K?v?ł??B
?@Ordinal?G???R?[?f?B???O?̓J?e?S???J???f?[?^???????ړx?????ꍇ?ɓK???Ă??܂??B??قǂ?'Pclass'??̗Ⴆ?b?𑱂???ƁA???̗?̒l??'S'?A'A'?A'B'?ł??ꂼ??1???A2???A3???̗??q?N???X??\???Ă????Ƃ???ƁA?????ɂ͏?????????̂Łi1????2????3???j?A???̃f?[?^???????ɉ??????????l?ɃG???R?[?f?B???O?ł???ł??傤?B
?@One-Hot?G???R?[?f?B???O?͖??`?ړx?????J?e?S???J???f?[?^???G???R?[?f?B???O????̂Ɍ????Ă??܂??B'Sex'????ɂƂ??2?̒l?ɑΉ?????V??????Ƃ???'male'???'female'???V?????쐬???A'Sex'??̒l??'male'?̃f?[?^??'male'??̃f?[?^??1?ɁA'female'??̒l??0?ɂ???Ƃ????????Ƃ????܂??i?t?????l?j?B???????A'Sex'???'Embarked'??̂悤?ɒl?̎?ނ????Ȃ???Η傫???????邱?Ƃ͂???܂??A??ނ??????Ƃ???ɔ????ė??????Ă??܂??\????????܂??B
?@?????ł?2?̗??One-Hot?G???R?[?f?B???O???Ă݂邱?Ƃɂ??܂??傤?B????ɂ?pandas.get_dummies?????g???܂??B
pandas.get_dummies??
pandas.get_dummies(data, prefix=None, prefix_sep='_', columns=None, dtype=None)
?@?J?e?S???J???f?[?^???_?~?[?ϐ??i?ڂ????͌?q????j?ɕϊ???????AOne-Hot?G???R?[?f?B???O??????ł???B?ꕔ?̃p?????[?^?[???ȉ??Ɏ????B?S?Ẵp?????[?^?[?ɂ??Ă?pandas?̃h?L???????g?upandas.get_dummies?v???Q?Ƃ̂??ƁB
- data?F?ϊ?????DataFrame?I?u?W?F?N?g
- prefix?F?ϊ???̃_?~?[?ϐ??̗?ɕt??????v???t?B?N?X?B?w?肵?Ȃ??????ꍇ?͌??̗x?????t???????
- prefix_sep?F?v???t?B?N?X?̌?ɕt???????Z?p???[?^?[
- columns?F?G???R?[?h????????????X?g?Ŏw?肷??
- drop_first?F?ϊ???̃_?~?[?ϐ???1??ڂ??폜???邩?iTrue?j?ǂ????iFalse?j?B?f?t?H???g??False
- dtype?F?V?????쐬?????̃f?[?^?^?B?ȗ??????ꍇ?̓u?[???A???l?iTrue?^False?j
?@?Ȃ??A?_?~?[?ϐ??Ƃ́A?J?e?S???J???f?[?^??0?܂???1?̒l?ɕϊ??????ϐ??̂??Ƃł??B?_?~?[?ϐ????́AOne-Hot?G???R?[?f?B???O?̈??ƌ??Ȃ??܂??B??ȈႢ?́A?_?~?[?ϐ????ł͒ʏ?A?????̃J?e?S???[?̂???1????Ƃ??Ďc???ϊ?????_???????ł??idrop_first?p?????[?^?[??True?ɂ?????ԁj?B?Ⴆ??'Sex'???ϊ?????ꍇ?A'female'??0?A'male'??1?Ƃ??邱?ƂŁA?Е??̕ϐ??i?Ⴆ??'male'??j??????lj????܂??B????ɂ??A?K?v?ȏ????????I?ɕێ??ł??܂??B?܂??A?????炷???ƂŁA??A???͂̑??d????????h???????b?g??????܂??B
?@DataFrame?I?u?W?F?N?g?̃??\?b?h?ł͂Ȃ????ł???_?ɂ͒??ӂ??Ă????????B'Sex'???'Embarked'???One-Hot?G???R?[?f?B???O???āA1??0?ɂ??????̂ł???A???̂悤?ȃR?[?h?ɂȂ?ł??傤?B
df6 = pd.get_dummies(df5, columns=['Sex', 'Embarked'], dtype=int)
df6
?@?????ł?pandas.get_dummies???ɕs?v?ȗ?̍폜?܂ł??s???????ʁidf5?j??n???Acolumns?p?????[?^?[?ɂ?'Sex'???'Embarked'????w?肵?āAdtype?p?????[?^?[?ɂ?int???w?肵?܂????B?ȉ??????s???ʂł??B
'Sex'?Ȃ??Ȃ?'Sex_female'???'Sex_male'?A'Embarked'?Ȃ??Ȃ?'Embarked_C'???'Embarked_Q'???'Embarked_S'?쐬???ꂽ?@'Sex'?Ȃ??Ȃ肻?̑????'Sex_female'???'Sex_male'?쐬????A???l??'Embarked'??̑????'Embarked_C'???'Embarked_Q'???'Embarked_S'?쐬???ꂽ???Ƃ???????܂??B
?@?V?????ł???DataFrame?I?u?W?F?N?g??info???\?b?h???Ăяo?????Ƃ??낪?ȉ??̉摜?ł??B
?S?Ă̗?̒l?????l?f?[?^?????ꂽ?@?S?Ă̗?̃f?[?^???????܂??͕????????_?^?̒l?ɂȂ?܂????B????Ȃ?@?B?I?ȏ????????܂???ꂻ???ł??B?Ƃ????Ƃ???ŁA????͏I???ł??B?O?????ł??Ȃ???Ȃ?Ȃ????Ɓi?f?[?^?̃X?P?[?????O?Ȃǁj???????????c???Ă??܂??B
?@???????A???̑O?ɍ???̐??ʂ?CSV?t?@?C???ɕۑ????Ă????܂??傤?B
df6.to_csv('titanic_cleaned.csv', index=False)
AI?E?f?[?^?T?C?G???X?̊w?т?????????
???S?Ҍ????A?f?[?^???́EAI?E?@?B?w?K?EPython?̕????@?@??IT??Deep Insider?Ŋw?ڂ?
Copyright© Digital Advantage Corp. All Rights Reserved.
?A?C?e?B???f?B?A????̂??m?点
??IT eBook
???ڂ̃e?[?}
?ҏW??????̂??m?点
RSS?ɂ???
?A?C?e?B???f?B?AID?ɂ???
???[???}?K?W???o?^
??IT?̃??[???}?K?W???́A ???????A???ׂĖ????ł??B???Ѓ??[???}?K?W???????w?ǂ????????B
ITmedia?̓A?C?e?B???f?B?A??????Ђ̓o?^???W?ł??B
???f?B?A?ꗗ | ????SNS | ?L???ē? | ???₢???킹 | ?v???C?o?V?[?|???V?[ | RSS | ?^?c??? | ?̗p??? | ??????