🎯 Key Takeaways for quick navigation: 00:00 📊 *Introduction to uploading Excel data into R* 00:15 📑 *Using Open Spreadsheet for universal accessibility* 00:28 🧹 *Importance of cleaning up the spreadsheet before uploading* 00:55 💾 *Saving the file in a simple text format, preferably CSV* 01:25 ⚠️ *Reminder about losing functionalities when saving in CSV format* 02:09 🔄 *Switching between CSV and XLSX formats for different purposes* 02:39 🖥️ *Opening the saved CSV in R- **02:52** 🗂️ Understanding the CSV format in RStudio* 03:05 📁 *Locating and specifying the file path in R* 03:33 🔙 *Handling backslashes in file paths for Windows in R* 04:13 📊 *Reading and displaying the data from CSV in R* 04:29 🔄 *Converting the CSV data into a data frame in R* 04:54 🛠️ *Adjusting CSV reading options like header and separators in R* 05:50 🧬 *Understanding the 'strings as factors' parameter in R* 06:17 📈 *Behavior of strings in different versions of R* Made with HARPA AI
@nanaurhopeАй бұрын
thank you
@geraldolson73643 жыл бұрын
Thanks again. Very clear and helpful.
@erickmetalsand90263 жыл бұрын
Man, thanks for your help!, I'm beginning with this and I found it helpful, I hope you can continue making videos cause you explain clear, ✌️
@ProgrammingDDS3 жыл бұрын
Thank you! Glad we could help :)
@efootball_tamil3 ай бұрын
Hey now have you learned R language completely?
@limumbapatrice2643 Жыл бұрын
Thank you G. I was really stuck in the Google analytics certification
@ahmed007Jaber Жыл бұрын
Thank u for this Managed to find away to accurately load xlsb files in r?
@christopherberggren6124 Жыл бұрын
Newbie here - have been attempting to import spreadsheets into R Studio using the read.csv function (I right-click to get the file path, copy and paste, convert the single back-slash to a double, and STILL getting error message. I've tried different methods too, like making sure to install and load tidyverse and here, then starting the read.csv function with a DF
@jackolson7071 Жыл бұрын
what if I have multiple sheets? It says I can't save excel file as csv with multiple sheets
@hoquocnam4232 Жыл бұрын
Thanks man, it helps alot
@relevant33293 жыл бұрын
You're the best. Thank yoy mate
@ProgrammingDDS3 жыл бұрын
Happy to help :)
@luziiluizth.87422 жыл бұрын
Awesome 👍👍 Thanks for sharing this with us ❤️
@kkyl51753 жыл бұрын
Thank you, great video
@palmkamaa4749 Жыл бұрын
Thanks Bro man👍
@golden_falcon91202 жыл бұрын
Hey I'm an ecologist and doing stuff with species abundance etc. As such, my first column is a list of taxonomic names and my sampling sites are the header. How do I get R to read my first column as a "header"?
@ProgrammingDDS2 жыл бұрын
Hi! If you look at the documentation for the read.csv function (www.rdocumentation.org/packages/xlsx/versions/0.6.5/topics/read.xlsx), you can see there is a "header" variable: "a logical value indicating whether the first row corresponding to the first element of the rowIndex vector contains the names of the variables.". Meaning you just have to set it to True to keep your header. Hope that helps! Best, Lilly
@abdullahaalmutlaq5868 Жыл бұрын
Thank you so much
@isabellekemajou-brown9232 жыл бұрын
Very informative video, thank you. I have a question if one may help. I am trying the command read.cvs and tried every step I see in your video but I keep getting error message "Error in read.cvs("path/filename.csv", : could not find function "read.cvs"" I tried both on windows and on mac and I am still having the same error message.
@abstract-thoughts2 жыл бұрын
You have it written as cvs and csv in this reply... make sure its always csv
@isabellekemajou-brown9232 жыл бұрын
@@abstract-thoughts Yes it works now. Thanks Chris!
@nguyennhatlong7773 Жыл бұрын
omg thank you alot
@mariatd0 Жыл бұрын
whenever I try to copy and paste the path file into read_excel, i get an "error: `path` does not exist". Does anyone know why this happens??
@AshuklaShukla-y5k8 ай бұрын
Same
@faezehfeizi1563 ай бұрын
Have you set your working directory ?
@kjeyaprakash26383 жыл бұрын
Please share on how to import Bam files in R
@meloanddiiv14182 жыл бұрын
what abour real world data things are not setup on the same way
@hugoalvaraes96922 жыл бұрын
What if column A has 5 observations and column B has 6 observations? How do we import in this situation?
@ProgrammingDDS2 жыл бұрын
Hi Hugo! The number of observations per column should not create problems when importing the data. You will probably have one "NA" in the row where there is no observation in column A. Hope that helps! Best, DDS
@hugoalvaraes96922 жыл бұрын
@@ProgrammingDDS Thanks for the feedback! Regards.
@evolutionentertainment4 ай бұрын
Your file properties has export into R why is that