A cikin duniyar nazarin bayanai, yin amfani da maƙunsar bayanai ya zama ruwan dare gama gari, musamman ma lokacin aiki tare da bayanan da aka tsara a cikin tsarin shafi. Ɗaya daga cikin shahararrun ɗakunan karatu don aiki tare da bayanan maƙunsar bayanai a Python shine Pandas. Wannan ɗakin karatu mai ƙarfi yana ba masu haɓaka damar karantawa, sarrafa, da fitar da bayanan tabular cikin sauƙi. A cikin wannan labarin, za mu mai da hankali kan takamaiman matsala: sabunta sel a cikin takarda ta sunan shafi ta amfani da Pandas. Za mu nutse cikin mafita, sannan bayanin mataki-mataki na lambar, kuma a ƙarshe za mu tattauna ra'ayoyi masu alaƙa da ayyuka a cikin Pandas, kamar aiki tare da firikwensin da zaɓin bayanai. Don haka, bari mu fara.
Ana sabunta Sel ta Sunan Rukunin Amfani da Pandas
Don sabunta sel a cikin takarda ta sunan shafi, da farko muna buƙatar shigar da ɗakin karatu na Pandas idan ba a riga an shigar da shi ta amfani da umarni mai zuwa ba:
!pip install pandas
Tare da shigar Pandas, bari mu zayyana matakan sabunta sel a cikin takarda ta sunan shafi:
1. Load da takardar a cikin wani abu DataFrame.
2. Samun dama ga sel da muke son sabuntawa.
3. Gyara sel da ake so ta hanyar sanya sabbin dabi'u.
4. Ajiye abin DataFrame baya zuwa takardar.
Ga snippet code wanda ke nuna mafita tare da misali mai sauƙi:
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)
Fahimtar Code
Mataki na farko shine shigo da ɗakin karatu na Pandas a ƙarƙashin sunan 'pd'. Bayan haka, dole ne mu loda bayanan daga fayil ɗin CSV zuwa cikin wani abu DataFrame ta amfani da aikin `pd.read_csv()`, yana ƙayyadad da sunan fayil ɗin shigarwa ('your_spreadsheet.csv').
Yanzu babban ɓangaren matsalar ya zo: samun dama da sabunta sel da ake so. A cikin wannan misalin, muna son sabunta ginshiƙin 'Shekaru' ta ƙara 1 zuwa kowace ƙima a cikin shafi. Muna yin haka ta hanyar ƙara 1 kawai zuwa ginshiƙi na 'Shekaru', wanda ake samun dama ta amfani da kalmar 'df['Age']'. Wannan lambar za ta yi ƙarin kashi-hikima na 1 ga kowane abu a cikin ginshiƙin 'Shekaru'.
A ƙarshe, muna ajiye sabunta DataFrame zuwa fayil ɗin CSV ta amfani da aikin `df.to_csv()` tare da sunan fayil ɗin fitarwa ('your_updated_spreadsheet.csv'). Ana amfani da sigar `index=Ƙarya' don guje wa rubuta lambobin jere zuwa fayil ɗin fitarwa.
Fihirisar Pandas da Zaɓin Bayanai
Pandas ya dogara kacokan akan manufar fihirisa don zaɓar da sarrafa bayanai. Ta hanyar tsoho, lokacin loda bayanai daga fayil, Pandas yana sanya a fihirisar lamba zuwa kowane jere na DataFrame, farawa daga 0. Lokacin aiki tare da bayanai a Pandas, yana da mahimmanci don fahimtar hanyoyi daban-daban na zabar da tace bayanai dangane da ƙimar fihirisa ko sunaye.
Misali, don zaɓar takamaiman jeri ko layuka, zaku iya amfani da maƙasudin `iloc`, wanda ke ba ku damar samun damar layuka dangane da maƙasudin su:
# 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]
Lokacin da kake buƙatar sabunta sel dangane da takamaiman yanayi, kamar sabunta ginshiƙin 'Shekaru' don waɗannan layuka kawai inda wani shafi (misali, 'Birni') yana da takamaiman ƙima, zaku iya amfani da alamar 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
A cikin wannan misali, ana amfani da alamar 'loc' don zaɓar layuka bisa yanayin bulo, sannan an sabunta ginshiƙin 'Shekaru'.
Ka tuna cewa wannan shine kawai ƙarshen ƙanƙara lokacin da ake yin aiki tare da bayanai a cikin Pandas. Laburaren yana ba da ɗimbin ayyuka da dabaru don sarrafa, bincika, da hango bayanan ku da kyau. Fahimtar mahimman bayanai, kamar sabunta sel a cikin takarda ta sunan shafi, yana kafa tushe mai ƙarfi don aiki tare da ƙarin rikitattun tsarin bayanai da ayyukan bincike a nan gaba.
