An warware: yi amfani da dict don maye gurbin pandas da suka ɓace

A cikin duniyar sarrafa bayanai da bincike, sarrafa abubuwan da suka ɓace aiki ne mai mahimmanci. Panda, ɗakin karatu na Python da ake amfani da shi sosai, yana ba mu damar sarrafa bayanan da suka ɓace yadda ya kamata. Hanya ɗaya ta gama gari don mu'amala da ƙimar da ta ɓace ta haɗa da amfani da ƙamus don taswira da maye gurbin waɗannan ƙimar. A cikin wannan labarin, za mu tattauna yadda za a yi amfani da ikon Pandas da Python don amfani da ƙamus don maye gurbin ƙimar da suka ɓace a cikin bayanan bayanai.

Magani

Maganin farko da za mu bincika shine amfani da cika () aiki tare da kamus. Wannan hanyar za ta ba mu damar musanya ƙimar da suka ɓace tare da madaidaitan dabi'u daga ƙayyadadden ƙamus.

Bayanin mataki-mataki na lambar

Don misalta wannan tsari, bari mu ɗauka muna da bayanan da ke ɗauke da bayanai game da salon salo iri-iri, gami da tufafi, launuka, da mahallin tarihi. A wasu lokuta, ƙila a sami rasa ƙima a cikin wannan saitin bayanai.

Da farko, shigo da dakunan karatu masu mahimmanci kuma ƙirƙirar samfurin DataFrame:

import pandas as pd

data = {
    'style': ['Grunge', 'Bohemian', 'Preppy', None, 'Punk', 'Casual'],
    'garments': ['Plaid shirt', None, 'Blazer', 'Maxi dress', 'Leather jacket', 'T-shirt'],
    'colors': ['Black', 'Faded', 'Light', 'Earthy', None, None]
}

df = pd.DataFrame(data)

Yanzu da muna da DataFrame da ke kwatanta matsalar, lura cewa wasu ƙididdiga sun ɓace (Babu wanda ke nuna shi). Don maye gurbin waɗannan ƙimar, ƙirƙiri ƙamus masu ɗauke da taswira masu dacewa:

style_dict = {None: 'Unknown'}
garments_dict = {None: 'Other'}
colors_dict = {None: 'Various'}

# Combine dictionaries
replacement_dict = {'style': style_dict, 'garments': garments_dict, 'colors': colors_dict}

A ƙarshe, yi amfani da cika () aiki don maye gurbin ƙimar da suka ɓace ta amfani da ƙamus ɗin da aka haɗa:

df_filled = df.fillna(replacement_dict)

Fahimtar ɗakin karatu na Pandas

Panda babban ɗakin karatu ne a cikin Python wanda aka tsara don sarrafa bayanai da bincike. Yana ba da tsarin bayanai masu sassauƙa da ƙarfi kamar Series da DataFrame. Waɗannan sifofi suna da mahimmanci don yin aiki da kyau tare da tsararrun bayanai, tambura.

Pandas yana ba da tarin ayyuka masu yawa, kamar cika (), ana amfani dashi don sarrafa bayanan da suka ɓace. Sauran ayyuka, kamar haɗa bayanai, bayanan pivoting, da bincike-lokaci-lokaci, ana iya yin su ba tare da wata matsala ba tare da Pandas.

Ayyuka don sarrafa bayanan da suka ɓace

Bugu da kari ga cika () Pandas yana ba da wasu ayyuka da hanyoyi da yawa don magance bacewar bayanan, kamar:

  • sauka(): Cire layuka ko ginshiƙai tare da bacewar bayanai.
  • isna(): Ƙayyade abin da DataFrame ko jerin abubuwan da suka ɓace ko ɓace.
  • ba (): Ƙayyade abin da DataFrame ko jerin abubuwan ba su ɓace ko ɓacewa.
  • interpolate(): Cika ƙimar da ta ɓace ta amfani da tsaka-tsakin layi.

Wadannan hanyoyin, tare da cika (), samar da cikakkun kayan aiki don sarrafa bayanan da suka ɓace a cikin yanayi daban-daban.

A ƙarshe, wannan labarin ya nuna yadda ake amfani da shi nuna don maye gurbin ƙimar da suka ɓace a cikin Pandas DataFrame. Babban aikin da muka yi amfani da shi, cika (), kayan aiki ne mai ƙarfi a cikin ɗakin karatu na Pandas wanda ke ba mu damar sarrafa bayanan da suka ɓace da kyau. Ta hanyar yin amfani da ƙamus, za mu iya taswirar ƙimar ƙimar da ba ta dace ba don maye gurbin da suka dace da tabbatar da cewa saitin bayanan mu cikakke ne kuma yana da ma'ana. Ta hanyar zurfin fahimtar ɗakin karatu na Pandas da ayyukan da aka haɗa, za mu iya yin aiki tare da manyan bayanan bayanai yadda ya kamata kuma mu zana mahimman bayanai daga bayananmu.

Shafi posts:

Leave a Comment