Skip to content

Latest commit

 

History

History
133 lines (69 loc) · 10.5 KB

doing-data-science-kaggle-walkthrough-cleaning-data.md

File metadata and controls

133 lines (69 loc) · 10.5 KB

�唳蝘郎摰�嚗aggle �唳皜���

��嚗https://www.kdnuggets.com/2016/03/doing-data-science-kaggle-walkthrough-cleaning-data.html](https://www.kdnuggets.com/2016/03/doing-data-science-kaggle-walkthrough-cleaning-data.html)

雿��Brett Romero嚗pen Data Kosovo��

*餈��喃��唳皜���蝡銝�銝芰頂�葉�洵銝��蝟餃���Kaggle蝡��Z悄�唳蝘郎��典郎銋����餈瓷��霂鳴�撱箄悅雿��駁�霂蒜蝚砌��典�](http://brettromero.com/wordpress/data-science-a-kaggle-walkthrough-introduction/)�蝚砌��典�](http://brettromero.com/wordpress/data-science-a-kaggle-walkthrough-understanding-the-data/)*��

�祇����單釣皜�Airbnb Kaggle蝡�銝剜�靘��唳��

![��孫(../Images/9cccd97cf0197adc18e3a221a9c4dbde.png)

�唳皜�

敶�隞祈�霈箸�格��嚗�隞祉弦蝡靚捏隞�銋��虜嚗�鈭箔賑靚捏�唳皜��塚�隞賑���臭�鈭雿��捆嚗�

  1. 靽桀��澆� �� �唳�其�銝�蝘撘�摮�頧祆�啣銝�蝘撘嚗�憒�隞SV頧祆�訐ython嚗����唳�航��甇�&頧祆�銝�蝭�蝡葉嚗�隞祉��唬�銝芸�憟賜�靘��csv銝哨�timestamp_first_active���怠�20090609231247餈�摮����舫��撘��園�喉�2009-06-09 23:12:47����桃�銝�銝芸�極雿停�臭耨甇��鈭掩���桅���

  2. 憛怨‘蝻箏仃�� �� 甇���賑�函洵鈭�葉���瘀��唳�葉���潛撩憭望�詨�撣貉�����虜�����靽⊥瘝⊥�鋡急����撩憭望�格����★嚗��V�霂衣�隞���

  3. 靽格迤�秤�� �� 撖嫣��������潭��曆�甇�&��憒���批��銝剖�質��乩�銝�銝芣摮���僑樴��銝剖�質��乩�銝�銝芾�頞�100��潦��鈭�潮�閬◤靽格迤嚗��隞亦&摰迤蝖桀�潛�霂���霈曆蛹蝻箏仃�潦��

  4. ���掩�� �� 餈�耨甇��霂臬�潑��銝�銝芸�蝐餃嚗�蝘�格���撣詨虜閫��澆��孵���霈詨�嚗�����嚗��萎�嚗��唳�湔隞�瑟�嚗陘�嗆雿輻�芰�摮挾�塚��澆��秤�祗閮�撌桀��隞�蝝�撖潸�詨�蝑�隞亙�蝘撘�靘��憒��冽��摰嗥��唳�塚�憒��冽瘝⊥��������賢振�”嚗�桐葉銝�踹��唬�����賢振��蝘��靘�嚗SA�nited States�.S. 蝑��蜓閬�皜�隞餃銋��虜�臬�餈��潭���嚗&靽�銝芸�澆��銝芰��研��

憭�蝻箏仃�唳��★

蝻箏仃�唳�虜�舀�格���蝔葉颲����桅�銋��之�港�嚗�銝斤�閫��寞�嚗�

1. �/敹賜蝻箏仃�潛�銵�

�W笆蝻箏仃�潭嚗�蝞���閫��寞��航悌蝏芋�銝蝙�典��怎撩憭勗�潛�霈啣�����典�憪��文之��銋�嚗�銝�鈭憸�閬釣���

擐�嚗�蝘瘜�蝻箏仃�唳���啁撖嫣��唳�霂湔�颲��嗆���銋������曹�蝻箏仃�澆紡�港���閬��斤��唳��餈��唳��10%撌血嚗��航��閬��啗����

蝚砌�銝芷憸嚗蛹鈭��文��怎撩憭望�桃�銵�雿�憿餌&霈支����銝��怠隞�銝剜瓷��靽⊥��憒��典���Airbnb�唳�葉嚗�隞砍��啗捂憭�瑟瓷��靘�隞祉�撟湧���隞祈�血�霈暸�銝�靘僑樴��冽銝�靘僑樴��冽�舐��嚗��臭�隞砍�賭誨銵其�銝�蝘��掩���冽嚗�賣�游僑�蹂��湔釣��蝘��冽嚗�甇文�賢�霈輸�賢振�嗡��銝��蝑�憒�蝑��臬����賑�航銝���隞��方�鈭扇敶��

2. 憛怨‘蝻箏仃��

憭�蝻箏仃�唳�洵鈭�撟踵��★�舐銝�銝芸�澆‵銵亦撩憭勗�潦��摨砲雿輻隞�銋�澆嚗��鈭�蝟餃���嚗��砌�撠�憛怨‘��桃掩���

憒��唳�臬�蝐餅�殷��喳摰嗚�挽憭掩��嚗��航��銋��臬�撱箔�銝芣蝐餃�亥”蝷算��乒��銝�蝘��航�舐霂亙�銝剜�撣貉���潘�隡嚗‵銵亦撩憭勗�潦����曹�餈��臬‵銵亦撩憭勗�潛�撟踵��寞�嚗��航隡�����桀�/�蝙��蝏芋���&�折�雿��

撖嫣��啣�潛掩���唳嚗�憒僑樴�嚗�餈��嗡��★�鈭餈��銝蝙�其��啣‵銵亙�潭�銋�憭改��賑�臭誑�嫣蛹雿輻��潭�銝凋��啜��隞祉��喳隞亙鈭隞��恣蝞像��潑���憒��寞�鈭�country_destination`��瑞�撟喳�撟湧��亙‵銵亦撩憭梁�撟湧��潦��

撖嫣�銝斤�蝐餃���殷��掩�唳��潭�殷�嚗�隞砌��臭誑雿輻�游����寞��亙‵銵亦撩憭勗�潦����嚗�隞砍隞乩蝙�函掩隡潔�憸�country_destination�瘜憸��嗡��葉��潘�餈��寞��箔�撌脩���桃���停�撱箸芋餈�銝凋��瘀�餈��寞�����撠賜��孵�摰嚗���隡祕蝏�餈啜���單迨銝駁��憭縑�荔�[orange Python摨(http://docs.orange.biolab.si/reference/rst/Orange.feature.imputation.html)��鈭�鈭�脩��﹝��


�賑��銝紋蝔��

1. Google蝵�摰霂髡 - �����蝏��刻�銝�瘨胯��

2. Google�唳��銝�霂髡 - ��雿��唳������

3. Google IT�舀�銝�霂髡 - �舀�雿�蝏��T��瘙�


�游��詨銝駁�

霂撟嗅‵�隞撩憭勗�澆�

隞笆�唳�霂衣���銝哨�雿�質�隡��唳�銝��撩憭勗�潑��first_affiliate_tracked` ����扳�隞砌���嗡��葉憛怠�蝻箏仃�潛��寞�嚗�冽�隞砌�憛怠�餈����潦��

# Fill first_affiliate_tracked column
print("Filling first_affiliate_tracked column...")
df_all['first_affiliate_tracked'].fillna(-1, inplace=True)

餈停�券鈭�嚗�

撖寞�桀����撉�鈭箏�賭�閫��賑撖寡�鈭�桃�皜���銝�����臬笆��aggle 瘥���銝芸末憭����桐���閬�憭�皜�嚗�銝箸�格�靘�僎銝���銝����曉甇支��捂憭�啣�銝��唳銝剖�賭���憸�憒���餈堆��刻�銝芣�桅�銝剖僎銝��剁���鈭�隞砍之��氬��

�嗉��餈��詨笆蝞���皜�餈�銋�霂�隞穿��喃蝙�唳��靘��◎�舀���������撠���隞�颱���鈭���閬����

銝�甈�

�其�銝��典�銝哨��賑撠��孵瘜冽�株蓮�W��孵���嚗���撱箔�銝芾悌蝏�桅�嚗��雿踵芋���箸憟賜�憸��蛹鈭&靽�銝���嚗蝙�其��Y�霈a����

[1] 撖嫣�����憭�格���撉�鈭綽�雿�賭����唳迨�嗆挾撠�霂�桀�霈剔��唳�僎撟嗡��舀�雿喳�頝萸��雿喳�頝菜�踹��其遙雿�桅�憭��芋����/撉�甇仿炊銝凋蝙�冽�霂�桅�嚗誑�踹�餈������刻�甈⊥�韏��銝��曹��賑�芣霂�遣銝�銝芸�蝐餃�銝�銝��唳��璅∪�嚗�甇斗�憭批�霂交�桅�璅∪���蝖格�扳銝餉��單釣�嫘��

蝞�隞� 撣�嗽瑞�璇� �臭�雿�桀���嚗�憭葵�賢振��銝���踹��恣�霂W���嚗�撌乩�蝏����隞蝘揣瘝��桅�隞��熙�遙�唳憿暸嚗����賢��恣�蔡嚗NDP嚗誑�撘��暹�桃�蝝X�](http://opendatakosovo.org/)蝑�撅��雿��

����霈詨頧祈蝸��

�詨嚗�


�賑��銝葵霂曄��刻�

1. Google 蝵�摰霂髡 - 敹恍���亦�蝏��刻�銝�瘨胯��

2. Google �唳��銝�霂髡 - ��雿��唳���賢�

3. Google IT�舀�銝�霂髡 - 銝箔���蝏�靘T�舀�


�詨��