Kuxazululiwe: faka ama-panda amakholomu amaningi

Isibuyekezo sokugcina: 09/11/2023
Author: I-Python SourceTrail

I-Pandas iwumtapo wezincwadi wePython onamandla futhi oguquguqukayo osetshenziswa kabanzi ukukhohlisa nokuhlaziya idatha. Imfuneko eyodwa evamile lapho usebenza ngedatha ukufaka amakholomu amaningi ku-DataFrame. Kulesi sihloko, sizohlola inqubo yokwengeza amakholomu amaningi ku-DataFrame sisebenzisa umtapo wezincwadi we-Pandas, sixoxe ngekhodi, futhi singene sijule emisebenzini ehlobene, amalabhulali, nemiqondo engakusiza ukuthi ube uchwepheshe we-Pandas.

Ukwengeza Amakholomu Amaningi ku-Pandas DataFrame

Ukuze sifake amakholomu amaningi ku-DataFrame, sizosebenzisa umsebenzi we-concat otholakala kulabhulali ye-Pandas. Lo msebenzi ukuvumela ukuthi uhlanganise ama-DataFrames amaningi eceleni komunye nomunye, kungaba ngemigqa noma amakholomu. Uma sifaka amakholomu amasha, sizohlanganisa ama-DataFrames ngamakholomu. Ake siqale ngesisombululo senkinga yethu.

import pandas as pd

# Create a sample DataFrame
data = {
    'A': [1, 2, 3],
    'B': [4, 5, 6]
}
df = pd.DataFrame(data)

# Create new columns to be inserted
new_columns = {
    'C': [7, 8, 9],
    'D': [10, 11, 12]
}
new_df = pd.DataFrame(new_columns)

# Insert new columns into the existing DataFrame
result = pd.concat([df, new_df], axis=1)

print(result)

Incazelo Yesinyathelo Nesinyathelo Yekhodi

Esibonelweni sethu, sizodlula kunqubo isinyathelo ngesinyathelo ukuqonda ukuthi ikhodi isebenza kanjani.

1. Okokuqala, singenisa umtapo wolwazi odingekayo, i-Pandas, ngokusebenzisa i- import pandas njenge- pd . Lokhu kusenza sikwazi ukusebenzisa imisebenzi ye-Pandas kusikripthi sethu.

2. Okulandelayo, sakha isampula ye-DataFrame ebizwa ngokuthi i-df kanye ne-DataFrame entsha yamakholomu amasha, i-new_df.

3. Ukufaka amakholomu amasha (new_df) ku-DataFrame yethu yokuqala (df), sisebenzisa umsebenzi we -pd.concat . Ngokucacisa i-axis=1 , sitshela umsebenzi ukuthi uhlangane eceleni kwamakholomu, sibeke amakholomu amasha eceleni kwe-DataFrame ekhona.

4. Ekugcineni, siphrinta umphumela we-DataFrame ukuze siqinisekise ukuthi amakholomu amasha afakwe ngendlela efanele.

Amacala Okusetshenziswa Okuthuthukile kanye Namasu

Ngenkathi umsebenzi we-concat uyithuluzi elinamandla lokufaka amakholomu amaningi ku-DataFrame, ungase uhlangabezane nezimo lapho udinga khona amasu athuthuke kakhulu ukuze ufeze izinjongo ezithile. Kulesi sigaba, sizoxoxa ngezinye izindlela ezimbalwa ezingakusiza ube umpetha ekuphatheni ama-DataFrames usebenzisa umtapo wezincwadi we-Pandas.

  • Faka Ikholomu Endaweni Ethize

Ezimweni lapho udinga ukufaka ikholomu endaweni ethile ku-DataFrame, indlela yokufaka iyindlela ewusizo. Le ndlela ikuvumela ukuthi ufake ikholomu ngaphambi kwenkomba ethile. Nasi isibonelo sekhodi:

# Insert column 'E' with values [13, 14, 15] before index 1 (after the first column)
df.insert(1, 'E', [13, 14, 15])

  • Faka Amakholomu Asuselwe Kwamanye Amakholomu

Kwesinye isikhathi, ungase ufune ukufaka amakholomu amasha athathwe kwamanye amakholomu ku-DataFrame. Ungenza izibalo kudatha ekhona ukuze udale lawa makholomu amasha. Isibonelo, ukubala umkhiqizo wamakholomu 'A' kanye no-'B':

df['F'] = df['A'] * df['B']

Kulesi sihloko, sixoxe ngendlela yokufaka amakholomu amaningi ku- Pandas DataFrame sisebenzisa umsebenzi we-concat , safunda incazelo yesinyathelo ngesinyathelo yekhodi, futhi sahlola izimo zokusebenzisa ezithuthukisiwe namasu. Ngalolu lwazi, manje usungakwazi ukuphatha idatha yakho ngempumelelo futhi usebenze kahle emisebenzini yakho yokuhlaziya idatha.

Okuthunyelwe okuhlobene: