Ehlabathini lokuhlalutya idatha, ukusetyenziswa kweespredishithi kuqhelekileyo, ngakumbi xa usebenza kunye nedatha ehleliweyo kwifomathi yekholomu. Elinye lamathala eencwadi adumileyo okusebenza ngedatha yespreadsheet kwiPython yiPandas. Eli thala leencwadi linamandla livumela abaphuhlisi ukuba bafunde, balawule, kwaye bathumele ngaphandle idatha yetheyibhile ngokulula. Kule nqaku, siza kugxila kwingxaki ethile: ukuhlaziya iiseli kwiphepha ngegama lekholomu usebenzisa iPandas. Siza kungena kwisisombululo, silandelwa yinkcazo yesinyathelo-nge-nyathelo yekhowudi, kwaye ekugqibeleni sixoxe ngeengcamango ezinxulumene nokusebenza kwiiPandas, ezifana nokusebenza kunye nezalathisi kunye nokukhetha idatha. Ngoko, masiqalise.
Ukuhlaziya iiSeli ngeGama leKholam Ngokusebenzisa iiPanda
Ukuhlaziya iiseli kwiphepha ngegama lekholomu, kufuneka kuqala sifake ithala leencwadi lePandas ukuba ayikafakwanga kusetyenziswa lo myalelo ulandelayo:
!pip install pandas
NgePandas efakiweyo, makhe sithethe amanyathelo okuhlaziya iiseli kwiphepha ngegama lekholomu:
1. Layisha iphepha kwinto yeDathaFrame.
2. Fikelela kwiiseli esifuna ukuzihlaziya.
3. Guqula iiseli ezifunwayo ngokunika amanani amatsha.
4. Gcina into ye-DataFrame emva kwiphepha.
Nantsi isicatshulwa sekhowudi esibonisa isisombululo ngomzekelo olula:
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 iKhowudi
Inyathelo lokuqala kukungenisa ngaphandle ilayibrari yePandas phantsi kwesibizo `pd`. Okulandelayo, kufuneka silayishe idatha esuka kwifayile ye-CSV kwi-DataFrame into kusetyenziswa `pd.read_csv()` umsebenzi, uchaza igama lefayile yegalelo ('your_spreadsheet.csv').
Ngoku kuza inxalenye ephambili yengxaki: ukufikelela kunye nokuhlaziya iiseli ezifunwayo. Kulo mzekelo, sifuna ukuhlaziya ikholamu 'yobudala' ngokongeza u-1 kwixabiso ngalinye kwikholamu. Senza oku ngokongeza nje u-1 kwikholamu 'Yobudala', efumaneka kusetyenziswa i-syntax `df['Age']`. Le khowudi iya kwenza ukudibanisa okulumkileyo kwe-1 kwinto nganye kwikholamu 'Yobudala'.
Okokugqibela, sigcina i-DataFrame ehlaziyiweyo emva kwifayile ye-CSV sisebenzisa `df.to_csv()` umsebenzi ngegama lefayile yemveliso ('your_updated_spreadsheet.csv'). I `index=False` parameter isetyenziswa ukunqanda ukubhala amanani omqolo kwimveliso yefayile.
Izalathisi zePanda kunye nokuKhetha iDatha
IiPandas zithembele kakhulu kwingqikelelo yezalathisi zokukhetha kunye nokukhohlisa idatha. Ngokungagqibekanga, xa ulayisha idatha kwifayile, iPandas inika a isalathiso samanani kumqolo ngamnye weSakhelo seDatha, ukuqala ku-0. Xa usebenza ngedatha kwiPandas, kubalulekile ukuqonda iindlela ezahlukeneyo ukukhetha kunye nokucoca idatha ngokusekelwe kumaxabiso esalathiso okanye amagama eekholam.
Umzekelo, ukukhetha umqolo othile okanye iirowu ezithile, ungasebenzisa `iloc` indexer, ekuvumela ukuba ufikelele kwimiqolo esekelwe kwinani elipheleleyo lesalathiso:
# 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]
Xa ufuna ukuhlaziya iiseli ngokusekwe kwimeko ethile, njengokuhlaziya ikholamu 'Yobudala' kuphela kuloo migca apho enye ikholamu (umz., 'Isixeko') inexabiso elithile, ungasebenzisa i-boolean indexing:
# 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
Kulo mzekelo, isalathisi `loc` sisetyenziswa ukukhetha imiqolo esekwe kwimeko ye boolean, kwaye ke ikholamu ethi 'Age' ihlaziywa.
Gcina ukhumbule ukuba oku kukuphela kwencam ye-iceberg xa kuziwa ekusebenzeni ngedatha kwiPandas. Ithala leencwadi libonelela ngobuninzi bemisebenzi kunye nobuchule bokusebenzisa, ukuhlalutya, kunye nokubona idatha yakho ngokufanelekileyo. Ukuqonda izinto ezisisiseko, ezifana nokuhlaziya iiseli kwiphepha ngegama lekholomu, kubeka isiseko esomeleleyo sokusebenza kunye nezakhiwo zedatha ezinzima kunye nemisebenzi yokuhlalutya kwixesha elizayo.
