Emhlabeni wokuhlaziywa kwedatha, ukusetshenziswa kwamaspredishithi kuvamile, ikakhulukazi uma kusebenza nedatha ehlelekile ngefomethi yekholomu. Enye yemitapo yolwazi edumile yokusebenza ngedatha yesipredishithi kuPython yiPandas. Lo mtapo wolwazi onamandla uvumela onjiniyela ukuthi bafunde, balawule, futhi bathumele idatha yethebula kalula. Kulesi sihloko, sizogxila enkingeni ethile: ukuvuselela amaseli eshidini ngegama lekholomu kusetshenziswa amaPanda. Sizongena esixazululweni, silandelwe incazelo yesinyathelo nesinyathelo sekhodi, futhi ekugcineni sixoxe ngemiqondo ehlobene nokusebenza kumaPanda, njengokusebenza ngezinkomba nokukhetha idatha. Ngakho-ke, ake siqale.
Ibuyekeza Amaseli Ngegama Lekholomu Kusetshenziswa Ama-Panda
Ukuze ubuyekeze amaseli eshidini ngegama lekholomu, sidinga kuqala ukufaka ilabhulali ye-Pandas uma ingakafakwa vele kusetshenziswa umyalo olandelayo:
!pip install pandas
Ngama-Panda afakiwe, ake siveze izinyathelo zokuvuselela amaseli eshidini ngegama lekholomu:
1. Layisha ishidi entweni ye-DataFrame.
2. Finyelela kumaseli esifuna ukuwabuyekeza.
3. Shintsha amaseli owafunayo ngokunikeza amanani amasha.
4. Londoloza into ye-DataFrame emuva eshidini.
Nawa amazwibela ekhodi abonisa isixazululo ngesibonelo esilula:
import pandas as pd
# Load data from a CSV file into a DataFrame object
df = pd.read_csv('your_spreadsheet.csv')
# Access and update the desired cells - let's update column 'Age' by adding 1 to each value
df['Age'] = df['Age'] + 1
# Save the updated DataFrame back to the CSV file
df.to_csv('your_updated_spreadsheet.csv', index=False)
Ukuqonda Ikhodi
Isinyathelo sokuqala ukungenisa ilabhulali ye-Pandas ngaphansi kwesibizo esithi `pd`. Okulandelayo, kufanele silayishe idatha esuka efayeleni le-CSV siye entweni ye-DataFrame sisebenzisa umsebenzi othi `pd.read_csv()`, ocacisa igama lefayela lokufaka ('your_spreadsheet.csv').
Manje kufika ingxenye eyinhloko yenkinga: ukufinyelela nokuvuselela amaseli owafunayo. Kulesi sibonelo, sifuna ukubuyekeza ikholomu 'Yobudala' ngokwengeza inani elingu-1 kukholomu ngayinye. Senza lokhu ngokumane sengeze oku-1 kukholamu 'Yobudala', efinyelelwa kusetshenziswa i-syntax ethi `df['Age']`. Le khodi izokwenza ukwengeza okuhlakaniphile kwesici koku-1 entweni ngayinye kukholomu 'Yobudala'.
Ekugcineni, silondoloza i-DataFrame ebuyekeziwe emuva kufayela le-CSV sisebenzisa umsebenzi othi `df.to_csv()` ngegama lefayela eliphumayo ('your_updated_spreadsheet.csv'). Ipharamitha ethi `inkomba=Amanga` isetshenziselwa ukugwema ukubhala izinombolo zomugqa efayeleni eliphumayo.
Izinkomba zePandas kanye Nokukhetha Idatha
AmaPanda athembele kakhulu kumqondo wezinkomba zokukhetha nokukhohlisa idatha. Ngokuzenzakalelayo, lapho ulayisha idatha efayeleni, i-Pandas yabela a inkomba yezinombolo kumugqa ngamunye we-DataFrame, kusukela ku-0. Uma usebenza nedatha kuma-Panda, kubalulekile ukuqonda izindlela ezahlukene ukukhetha nokuhlunga idatha ngokusekelwe kumanani ezinkomba noma amagama ekholomu.
Isibonelo, ukuze ukhethe umugqa noma imigqa ethile, ungasebenzisa inkomba ethi `iloc`, ekuvumela ukuthi ufinyelele imigqa ngokususelwe enkombeni yabo ephelele:
# Select the first row of the DataFrame first_row = df.iloc[0] # Select rows 1 to 3 (excluding 3) rows_1_to_2 = df.iloc[1:3]
Uma udinga ukubuyekeza amaseli ngokusekelwe esimweni esithile, njengokubuyekeza ikholomu 'Yobudala' kuleyo migqa kuphela lapho enye ikholomu (isb., 'Idolobha') inenani elithile, ungasebenzisa inkomba ye-boolean:
# Update the 'Age' column by adding 1, only for rows where 'City' is equal to 'New York' df.loc[df['City'] == 'New York', 'Age'] = df['Age'] + 1
Kulesi sibonelo, inkomba ethi `loc` isetshenziselwa ukukhetha imigqa esekelwe kusimo se-boolean, bese ikholomu 'Yobudala' ibuyekezwa.
Khumbula ukuthi lokhu kuyiphuzu nje le-iceberg uma kuziwa ekusebenzeni ngedatha kuma-Panda. Umtapo wolwazi uhlinzeka ngobuningi bemisebenzi namasu okukhohlisa, ukuhlaziya, kanye nokubona idatha yakho ngokuphumelelayo. Ukuqonda izinto eziyisisekelo, njengokubuyekeza amaseli eshidini ngegama lekholomu, kusetha isisekelo esiqinile sokusebenza nezakhiwo zedatha eziyinkimbinkimbi nemisebenzi yokuhlaziya esikhathini esizayo.
