Yakagadziriswa: pandas inotsiva column values

Pandas iraibhurari ine simba yePython inoshandiswa zvakanyanya pakugadzirisa data uye kuongorora. Kumwe kushanda kwakajairwa kunoitwa nedata kutsiva kukosha kwekoramu zvichibva pane mamwe maitiro, sekugadzirisa kana mepu kune humwe hunhu. Muchinyorwa chino, isu tichaongorora maitiro ekushandisa izvi zvinobudirira uchishandisa iyo Pandas raibhurari. Kunyangwe iwe uri sainzi wedata, mugadziri wezvirongwa, kana nyanzvi yefashoni iri kuongorora munyika yedata-inofambiswa nemafashoni mafambiro, ruzivo urwu ruchakoshesesa.

Kiyi yekunzwisisa oparesheni iyi iri mukugona mabasa akavakirwa-mukati anopihwa nePandas raibhurari. Kunyanya, isu tichatarisa mashandisirwo ekuti `tsiva()`, `mepu()`, uye `shandisa ()` mabasa ekugadzirisa makoramu zvichienderana nemaitiro akasiyana.

import pandas as pd

# Sample data
data = {'Fashion_Style': ['Boho', 'Grunge', 'Preppy', 'Vintage', 'Athleisure'],
        'Colors': ['Earthy tones', 'Dark shades', 'Bright tones', 'Muted tones', 'Monochrome']}

df = pd.DataFrame(data)

# Replacing column values
df['Colors'] = df['Colors'].replace(['Earthy tones', 'Monochrome'], ['Warm tones', 'Contrast tones'])

print(df)

Tsanangudzo-nhanho-nhanho yeCode

1. Chekutanga, tinopinza raibhurari yePandas se `pd`. Iyi igungano rakajairwa, uye rinotitendera kudaidza mabasa ePandas ne `pd` shorthand.
2. Tevere, tinogadzira duramazwi rinonzi `data` rine makolamu 'Fashion_Style' uye 'Mavara', pamwe chete nezvaanofarira.
3. Tinobva tagadzira DataFrame inodaidzwa kuti `df` tichishandisa `pd.DataFrame()` basa rine `data` duramazwi senharo.
4. Mushure mezvo, isu tinoshandisa `replace()` basa kutsiva chaiwo maitiro mu'Mavara' column. Mumuenzaniso wedu, tinotsiva 'Earthy tones' ne'Warm tones' uye 'Monochrome' ne'Contrast tones'.
5. Pakupedzisira, tinodhinda yakagadziridzwa DataFrame `df` kutarisa mhedzisiro.

Pandas Yakavakwa-mukati Mabasa eColumn Value Replacement

Pandas inopa akati wandei akavakirwa-mukati mabasa ekushanda nemakoramu makoramu muDataFrames. Pakati peizvi, takaona `tsiva()`, `mepu()`, uye `shandisa()` sezvinonyanya kubatsira kana zvasvika pakutsiva makoramu zvichienderana nemamiriro akasiyana.

kutsiva (): Iri basa rinoshandiswa kutsiva yakatarwa kukosha muDataFrame kana Series. Inogona kuiswa kune imwe koramu kana iyo yese DataFrame, uye inotsigira yakajairwa mataurirwo emhando yepamusoro yekufananidza.

df['Colors'] = df['Colors'].replace(['Earthy tones', 'Monochrome'], ['Warm tones', 'Contrast tones'])

mepu(): Iyo `mepu ()` basa rakafanana ne `replace()`, asi rinoshandisa rakapihwa basa kana duramazwi kune chimwe nechimwe chinhu muSeries. Izvi zvinogona kubatsira kana iwe uchida kumepu makolamu makoramu kune hunyowani hutsva hwakavakirwa pane yakatarwa seti yemitemo.

color_mapping = {'Earthy tones': 'Warm tones', 'Monochrome': 'Contrast tones'}
df['Colors'] = df['Colors'].map(color_mapping)

shandisa (): Iyo `apply()` basa chishandiso chine simba chinoshandisa basa rakapihwa pamwe neaxis yeDataFrame. Inogona kushandiswa paDataFrame yese kana makoramu chaiwo kuti uwane huwandu hwakasiyana hweshanduko.

def update_colors(color_value):
    if color_value == 'Earthy tones':
        return 'Warm tones'
    elif color_value == 'Monochrome':
        return 'Contrast tones'
    else:
        return color_value
        
df['Colors'] = df['Colors'].apply(update_colors)

Neaya mabasa aunawo, iwe wagadzirira kubata akasiyana siyana data manipulation mabasa muPandas, sekutsiva makolamu makoramu muDataFrames. Ruzivo urwu harungoshandi chete mumunda wesainzi yedata uye hurongwa asi zvakare hunoratidza kubatsira pakuongorora masitaera emazuva ano, kuona mafambiro ari kubuda, uye kunzwisisa kukosha kwenhoroondo yezvitaera nemavara akasiyana.

Related posts:

Leave a Comment