Umsebenzi wokukhipha i-DataFrame kufayela le-Excel ku-R ulula kakhulu inqubo yokuhlaziya idatha. Esikhundleni sokukopisha nokunamathisela idatha ku-Excel, noma okungenzeka kulahlekelwe ulwazi olubalulekile ekudluliselweni, ukuthekelisa i-DataFrame ngokuqondile ku-Excel kuyindlela ephumelelayo nethembekile yokwethulwa kwedatha, ukugcinwa, nokuhlaziya okwengeziwe.
Lapho efunda indlela yokwenza lo msebenzi, umuntu ngamunye uthuthukisa kakhulu amandla akhe okuphatha idatha ku-R. Akongi isikhathi kuphela, futhi kuqinisekisa ukulondolozwa kobuqotho bedatha.
Ngokusetshenziswa komsebenzi oyedwa, kanye nemitapo yolwazi ye-R efanelekile, lolu shintsho lungenzeka kalula.
Imitapo yolwazi yokuthunyelwa kwe-DataFrame
Kunemitapo yolwazi ka-R eminingana engasetshenziswa ukuthumela ama-DataFrames ku-Excel. Okuvame kakhulu phakathi kwabo yi- bhala.xlsx kusuka kuphakheji ye-"openxlsx".
install.packages("openxlsx") library(openxlsx)
Amanye amaphakheji ahlanganisa i-โwritexlโ ne-โxlsxโ, ngalinye elinesethi yalo ehlukile yemisebenzi yokuphatha ifayela ku-R.
Isixazululo: Ukusebenzisa umsebenzi wokubhala.xlsx
Umtapo wezincwadi we-โopenxlsxโ ku-R wenza kube lula inqubo yokuthekelisa i-DataFrame yakho ku-Excel. Lapha, sibonisa ukusetshenziswa kwayo sisebenzisa isibonelo sesinyathelo ngesinyathelo.
# Dala uhlaka lwedatha
idatha_frame <- data.frame(Names = c("Alice", "Bob", "Chris"), Scores = c(85, 92, 88)) # Sebenzisa umsebenzi wokubhala.xlsx ukuthumela uhlaka lwedatha ku-Excel write.xlsx (data_frame, "data_frame.xlsx") [/code] Kulesi sibonelo, amagama abasebenzisi kanye nezikolo zabo ezihambisanayo kuthwetshulwa "kufreyimu_yedatha" bese kuthunyelwa ku-Excel kusetshenziswa bhala.xlsx sebenza ku "Openxlsx" umtapo wolwazi.
Incazelo yeKhodi
Ekuqaleni, siyakha uhlaka lwedatha equkethe amagama nezikolo. Lolu hlaka lwedatha lube seludluliselwa ku- bhala.xlsx() umsebenzi.
Kumsebenzi we-writ.xlsx, i-agumenti yokuqala wuhlaka lwedatha ofuna ukuthekelisa futhi i-agumenti yesibili igama lefayela le-Excel (njengeyunithi yezinhlamvu), ofuna uhlaka lwedatha luthunyelwe kulo. Uma indlela ingacacisiwe, ifayela lizogcinwa kuhla lwemibhalo olusebenzayo lwamanje.
Umphumela uyifayela le-Excel elibizwa ngokuthi โdata_frame.xlsxโ eliqukethe ulwazi oluvela kuhlaka lwedatha, elingashintshwa ngokuqhubekayo noma lihlaziywe ku-Excel.
Uma usebenza ngozimele bedatha ku-R, kubaluleke kakhulu ukuphatha nokuphatha idatha yakho ngendlela efanele. Ukuthekelisa uhlaka lwedatha efayeleni le-Excel ngohlelo kuvumela ukuhlaziya idatha ephumelelayo, ethembekile, futhi enembile.
Ngaphezu kwalokho, ukuqonda indlela yokusebenzisa amandla emisebenzi yokuphatha idatha ye-R, njengomsebenzi we-writ.xlsx kulesi sibonelo, kubalulekile. Eminye imitapo yolwazi nemisebenzi yazo elandelanayo isebenza kuphela ekuthuthukiseni amandla okuphatha ifayela lomsebenzisi ku-R, iguqule indlela abahlaziya ngayo, ababelana ngayo, nabahumusha ngayo idatha.