Thank you!!!! My professor doesn’t provide the best information to complete our assignments and I’ve been struggling for hours but you made this simple to figure out in 3 minutes
Couple notes 1. Excel files have multiple pages, but CSV files may only have 1 2. The CSV must be formatted such that only a header and columns of homogeneous values are present (he alluded to this already by saying it will be read as a data frame rather than generally as a list) 3. The data frame and CSV will not save formulaic data from an Excel file, but rather just the final numerical output of those formulae to each cell 4. Obviously, it also doesn't save any aesthetic changes to the cells or font, so a lot of data may be lost in this transfer if the original file is Excel 5. CSVs cells also are not able to refer to cells from other files; they're kind of dumb in general.
Oh yeah, and very importantly, the headers for each column must be formatted properly in the CSV as SINGLE WORDS like "poop" or "poop_tuna". If they're named something "poop tuna" or "_+Bucky" they'll be unreadable.
Hey Bucky, I'm a new subscriber and I just want to tell you that I appreciate this tutorial. I have managed to get my brother who is a scientist in the field of biology to watch the first few episodes. Most scientists suck at programming and statistics so keep this up and we might be able to contribute to something bigger... like a non-sucky scientist :)
You probably dont give a shit but if you're bored like me atm you can watch pretty much all of the latest movies and series on InstaFlixxer. I've been streaming with my brother lately :)
Really thanks to u man , I love your explanation , the way of teaching. You know one thing ,because of you I did improve two things, 1) Rstdio and 2) English😂.......thanks you very much for your explanation and at the end I suggested your CHANNEL to my closest friends also....... and one thing , I heard the name BUCKY in captain america...😇
It is also possible to just write F/T instead of FALSE/TRUE and everything will be the same. Plus you can use read.table function that can also make the same data.frame and I hope you will show attach function next time (just a small hints) I really love your tuts and I hope I will learn much more from your vids. You are making this world better! :)
Fellow beginner/ R noob brothers & sisters, if you see "No such file or directory", try changing the file name to just brUsers instead of brUsers.csv, it worked in my PC!
i keep getting Error in file(file, "rt") : cannot open the connection In addition: Warning message: In file(file, "rt") : cannot open file 'SEO': No such file or directory
Hi Sr. Thank you so much. But if I have this error , what I should do ? Error in read.table(file = file, header = header, sep = sep, quote = quote, : more columns than column names I'm in trouble to read csv file Thanks so much!
This may be a silly question- how do I know what I need to type in the top left box for R to run? Sorry this is my first R tutorial and I am completely lost.
file not found! i am reciving this message for 3 days, i am getting mad! , i´ve already change my working directory, y cheked everithing, i dont know what more i must do
I have successfully loaded a csv file (downloaded as csv from an excel sheet). However, while reading the file, it shows many metadata such as font style, font style etc in the R console. Why is this? Can anyone help me?
You have to set the working directory to My documents. Or you can set it to which ever folder you please. You need to click on Session and get access to the working Directory. Cheers!!
Here's a linear regression of the CSV file that used in this tutorial: ------------------------------------------------------------------------ csvFile
docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBymKDoqLLcKjPohtZkU/ this is the link but the file doesn't exits so you cant do much form that.
Thank you!!!! My professor doesn’t provide the best information to complete our assignments and I’ve been struggling for hours but you made this simple to figure out in 3 minutes
Couple notes
1. Excel files have multiple pages, but CSV files may only have 1
2. The CSV must be formatted such that only a header and columns of homogeneous values are present (he alluded to this already by saying it will be read as a data frame rather than generally as a list)
3. The data frame and CSV will not save formulaic data from an Excel file, but rather just the final numerical output of those formulae to each cell
4. Obviously, it also doesn't save any aesthetic changes to the cells or font, so a lot of data may be lost in this transfer if the original file is Excel
5. CSVs cells also are not able to refer to cells from other files; they're kind of dumb in general.
Oh yeah, and very importantly,
the headers for each column must be formatted properly in the CSV as SINGLE WORDS like "poop" or "poop_tuna". If they're named something "poop tuna" or "_+Bucky" they'll be unreadable.
Hey Bucky, I'm a new subscriber and I just want to tell you that I appreciate this tutorial. I have managed to get my brother who is a scientist in the field of biology to watch the first few episodes. Most scientists suck at programming and statistics so keep this up and we might be able to contribute to something bigger... like a non-sucky scientist :)
This video really helped me out a lot. I was confused, even in determining my working directory. Thank you!!
THERE IS NO LINK IN THE DESCRIPTION
link to the file : i typed it out
docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0
Thanks man
adam adam!
thanks!
well it must took years of years to type
You're the best!!
Can't wait for the next one ! Awesome series bucky
You probably dont give a shit but if you're bored like me atm you can watch pretty much all of the latest movies and series on InstaFlixxer. I've been streaming with my brother lately :)
@Watson Asa Yea, I have been watching on instaflixxer for since november myself :)
Still relevant.
As a newbie I'm blown away by this stuff haha
Really thanks to u man , I love your explanation , the way of teaching. You know one thing ,because of you I did improve two things, 1) Rstdio and 2) English😂.......thanks you very much for your explanation and at the end I suggested your CHANNEL to my closest friends also....... and one thing , I heard the name BUCKY in captain america...😇
Thanks a ton for these tutorials, you make learning programming simple and approachable :)
Thanks Bucky!!
This is a new program for me and your tutorials really help me!!
Keep it up!!
Thanks alot this my first time using the Rstudio and your videos are really helpful.
It is also possible to just write F/T instead of FALSE/TRUE and everything will be the same. Plus you can use read.table function that can also make the same data.frame and I hope you will show attach function next time (just a small hints)
I really love your tuts and I hope I will learn much more from your vids. You are making this world better! :)
Hi man I was specially looking for the last part of the video (online files). Do. Have a video explaining how to write online files?
This Video really helped me do my project. Thanks!!
Fellow beginner/ R noob brothers & sisters, if you see "No such file or directory", try changing the file name to just brUsers instead of brUsers.csv, it worked in my PC!
Thanks man, it works
Thanks for all your help. This was a great video
Great video man, helped me a lot.
thank you, simple and direct.
hey man just wanted to share my gratitude!
i keep getting Error in file(file, "rt") : cannot open the connection
In addition: Warning message:
In file(file, "rt") : cannot open file 'SEO': No such file or directory
Yo, make sure you type the full name of file and extension inside the inverted commas.
eg: "tuna.csv"
Try now!
I did type the extension and everything, but I continue to get the same error message
write file extension also
First time with R going through your videos. How do you all remember all these commands and stuff?
Wheres the link for the csv file? :(
your tutorials are amazing!
Hi Sr. Thank you so much.
But if I have this error , what I should do ?
Error in read.table(file = file, header = header, sep = sep, quote = quote, :
more columns than column names
I'm in trouble to read csv file
Thanks so much!
No link for the csv file =/
Create one at your own
he said he would put the link in the description
excel-> save as-> csv
Bucky, what if the csv sits behind a login and password, say SmartSheets? How can this be done? Thank you
Hi, there's no link to Google Drive.
docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0
Thanks to Tushar that posted this earlier in the comments.
Thanks. It worked in 2021
there is no link in description
This may be a silly question- how do I know what I need to type in the top left box for R to run? Sorry this is my first R tutorial and I am completely lost.
Hey Bucky when are we going to get the other videos about stats and graphs and all that good stuff ;)
Spreadsheet link for anyone who needs it docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0
After 5 years, I am commenting under your comment. Thank you.
the getwd doesnt even work for me it says function then internal getwd, I hate this thing
Where is CSV file link??
first error: more columns than column names.
second error file not foind, i had in in my Documents.
file not found! i am reciving this message for 3 days, i am getting mad! , i´ve already change my working directory, y cheked everithing, i dont know what more i must do
i did it!
Where is the google file?
bro you are heavy...thank you so much
Hi, bro. where's your .csv downloadable link?
No link to data set, Please add
I have successfully loaded a csv file (downloaded as csv from an excel sheet). However, while reading the file, it shows many metadata such as font style, font style etc in the R console.
Why is this? Can anyone help me?
Could you Please guide me how you have downloaded the file .
Life saver 😎 👍🏼
it would be nice if you zoomed in so that we can see the script
How can we set the path .....setwd()..getting error in Mac
R did not grab the info, I followed your instructions (using a mac), the file was in my documents.
You have to set the working directory to My documents. Or you can set it to which ever folder you please. You need to click on Session and get access to the working Directory.
Cheers!!
don't use mac lol
Here's a linear regression of the CSV file that used in this tutorial:
------------------------------------------------------------------------
csvFile
love you!!!!!!! it worked.... OMG
Hi Bucky, can you give as some tutor on matlab; specially on image processing using matlab.
Finally, I found Bucky...............
where is the link for csv file ?
Nice tutorial.! Please will make "Hadoop Tutorial".
VERY HELPFUL! THX!
Hi Guys,
Kindly find the link :)
docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU
thanks!!!
Hey bucky what happened ?
Yeh I was really looking forward to more.
Here's the link to the data for the second csv file:
samplecsvs.s3.amazonaws.com/Sacramentorealestatetransactions.csv
where's the link for the FIRST FILE
docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0
how to print attributes/header only
I watched every video in order and was with you up until this tutorial. I don't think this works with MAC
Values Bucky, comma separated values.
thank you. just, thank you :)
Sir I have a request.please make a video how to import data from minitab to R software. Please sir it's a humble request ☺️
Bucky, can you teach us Lua? Several games use this scripting language such as Gmod, and ROBLOX, and apparently Dont Starve. so does WoW.
where is the link
Hey Bucky, great series but you stopped when it started to get interesting (plotting).
R Programming Tutorial - 15 - How to Read CSV Files
Brendan Sullivan ohh really? xD
My man!!! 😂😂😂😂🎉🎉🎉
James Buchanan Barnes?
thanku❤❤❤❤❤❤
Thanks a lot!
thank you bro!
informative
useful keep it up
hey bucky, can you please upload more videos, i can't wait.
what does "tuna" mean?
It is a datatype where the .csv file is stored.
@@warrior_1309 so its constant for all R users? or is there a specific way to create that datatype
@@prudencemwiti9767 It is not constant. You can use any name to store a value.
it's a kind of fish
docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBymKDoqLLcKjPohtZkU/
this is the link but the file doesn't exits so you cant do much form that.
it is what it is
excellent
Comma Separated Values
thnaks man
comma separated values csv :D
thank you
Guys, that's the link:
docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0
Here you go: docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0
😎😎
First! :D
To die
jailbreak889 slowly and painfully...
nice
funny. all these videos. trying to teach the taught ones.
(u r not explaining what r u doing, what is what, and why, and where, and WHAT)
Mwahahaha time to hack clash of clans :p
Thank you, great Video
Thank you so much!
Thankyou so much!