Munyika yekuongorora data, kushandiswa kwemaspredishiti kwakajairika, kunyanya kana uchishanda nedata rakarongeka mune columnar fomati. Imwe yemaraibhurari anozivikanwa ekushanda nespredishiti data muPython iPandas. Iyi raibhurari ine simba inobvumira vanogadzira kuverenga, kushandura, uye kutumira data retabular zviri nyore. Muchikamu chino, tichatarisa pane rimwe dambudziko: kugadzirisa maseru mune pepa nezita rekoramu uchishandisa Pandas. Isu tichanyura mumhinduro, tichiteverwa nedanho-ne-nhanho tsananguro yekodhi, uye pakupedzisira tokurukura zvine hukama pfungwa uye kushanda muPandas, sekushanda nemaindex uye kusarudza data. Saka, ngatitangei.
Kuvandudza Masero neColumn Name Uchishandisa Pandas
Kuti tigadzirise maseru mune pepa nezita rekoramu, isu chekutanga tinoda kuisa raibhurari yePandas kana isati yatoiswa uchishandisa murairo unotevera:
!pip install pandas
NePandas yakaiswa, ngatitaurei matanho ekugadzirisa maseru mune pepa nezita rekoramu:
1. Isa pepa muchinhu cheDataFrame.
2. Svika maseru atinoda kugadzirisa.
3. Shandura masero anodiwa nekupa hutsika hutsva.
4. Chengetedza chinhu cheDataFrame kudzokera kupepa.
Heino kodhi snippet inoratidza mhinduro nemuenzaniso wakapfava:
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)
Kunzwisisa Code
Danho rekutanga nderekupinza Pandas raibhurari pasi pezita `pd`. Zvadaro, tinofanira kuisa data kubva kufaira reCSV kuisa muDataFrame chinhu tichishandisa `pd.read_csv()` basa, tichitsanangura zita refaira rekuisa ('your_spreadsheet.csv').
Ikozvino kunouya chikamu chikuru chedambudziko: kuwana uye kugadzirisa maseru anodiwa. Mumuenzaniso uyu, isu tinoda kugadzirisa iyo 'Zera' koramu nekuwedzera 1 kune yega kukosha mukoramu. Isu tinoita izvi nekungowedzera 1 kune iyo 'Zera' column, iyo inowanikwa uchishandisa syntax `df['Age']`. Kodhi iyi ichaita kuwedzera-kuchenjera kwe1 kune chimwe nechimwe chinhu mu 'Zera' column.
Pakupedzisira, tinochengetedza DataFrame yakagadziridzwa tichidzokera kufaira reCSV tichishandisa `df.to_csv()` basa rine zita refaira rekubuda ('your_updated_spreadsheet.csv'). Iyo `index=False` parameter inoshandiswa kudzivirira kunyora mitsara nhamba kune yakabuda faira.
Pandas Indexes uye Kusarudza Data
Pandas inotsamira zvakanyanya pane iyo pfungwa ye indexes yekusarudza nekugadzirisa data. Nekutadza, kana uchirodha data kubva kufaira, Pandas inopa a nhamba indekisi kumutsara wega wega weDataFrame, kutanga kubva pa0. Paunenge uchishanda nedata muPandas, zvakakosha kuti unzwisise nzira dzakasiyana dze kusarudza uye kusefa data zvichienderana neindex values kana column names.
Semuenzaniso, kusarudza mutsara chaiwo kana mitsara, unogona kushandisa iyo `iloc` indexer, iyo inokutendera iwe kuti uwane mitsetse zvichienderana neinteger index yavo:
# 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]
Paunenge uchida kugadzirisa maseru zvichibva pane chaiyo mamiriro, senge kugadzirisa iyo 'Zera' koramu kune iyo chete mitsara ine imwe koramu (semuenzaniso, 'Guta') ine imwe kukosha, unogona kushandisa 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
Mumuenzaniso uyu, iyo `loc` indexer inoshandiswa kusarudza mitsara inoenderana neiyo boolean mamiriro, uye ipapo iyo 'Age' column inovandudzwa.
Ramba uchifunga kuti iyi ingori chidimbu cheiyo iceberg kana zvasvika pakushanda nedata muPandas. Raibhurari inopa kuwanda kwemabasa uye matekiniki ekushandisa, kuongorora, uye kuona data rako nemazvo. Kunzwisisa izvo zvekutanga, sekuvandudza maseru mubepa nezita rekoramu, inoisa hwaro hwakasimba hwekushanda nemamwe akaomarara data zvimiro uye mabasa ekuongorora mune ramangwana.
