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
Ukufaka amakholomu amaningi ku-DataFrame, sizosebenzisa concat umsebenzi otholakala kumtapo wezincwadi wePandas. Lo msebenzi ukuvumela ukuthi uhlanganise ama-DataFrames amaningi eduze komunye nomunye, kungaba ngemigqa noma amakholomu. Lapho sifaka amakholomu amasha, sizohlanganisa ama-DataFrames kanye namakholomu. Ake siqale ngesixazululo 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, amaPanda, ngokuwenza ngenisa ama-pandas njenge-pd. Lokhu kusivumela ukuthi sisebenzise imisebenzi ye-Pandas kusikripthi sethu.
2. Okulandelayo, sakha isampula ye-DataFrame ebizwa df kanye ne-DataFrame entsha yamakholomu amasha, okusha_df.
3. Ukufaka amakholomu amasha (new_df) ku-DataFrame yethu yasekuqaleni (df), sisebenzisa pd.concat umsebenzi. Ngokucacisa i-eksisi=1, sitshela umsebenzi ukuthi uhambisane namakholomu, sibeke amakholomu amasha eduze 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
Ezimeni lapho udinga ukufaka ikholomu endaweni ethile ku-DataFrame, i ukufaka indlela 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, sihlanganise indlela yokufaka amakholomu amaningi ku-a I-Pandas DataFrame besebenzisa i concat umsebenzi, wafunda incazelo yesinyathelo ngesinyathelo sekhodi, futhi wahlola izimo ezithuthukile zokusetshenziswa nezindlela. Ngalolu lwazi, manje usungakwazi ukukhohlisa idatha yakho futhi uphumelele ngokwengeziwe emisebenzini yakho yokuhlaziya idatha.