R Programming Tutorial - 15 - How to Read CSV Files

Поделиться
HTML-код
  • Опубликовано: 4 окт 2024

Комментарии • 127

  • @BlueNovaBeats
    @BlueNovaBeats 4 года назад +5

    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

  • @healthcareactuary
    @healthcareactuary 8 лет назад +56

    link to the file : i typed it out
    docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0

  • @josephswietlik7013
    @josephswietlik7013 5 лет назад +22

    THERE IS NO LINK IN THE DESCRIPTION

  • @oralboytoy
    @oralboytoy 7 лет назад +8

    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.

    • @oralboytoy
      @oralboytoy 7 лет назад +3

      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.

  • @oathwine
    @oathwine 10 лет назад +10

    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 :)

  • @mackwhite7628
    @mackwhite7628 5 лет назад +1

    This video really helped me out a lot. I was confused, even in determining my working directory. Thank you!!

  • @WtFGankalot
    @WtFGankalot 2 года назад

    Still relevant.
    As a newbie I'm blown away by this stuff haha

  • @TheFluffyOtter
    @TheFluffyOtter 10 лет назад +4

    Can't wait for the next one ! Awesome series bucky

    • @watsonasa1975
      @watsonasa1975 3 года назад

      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 :)

    • @danieldominick2715
      @danieldominick2715 3 года назад

      @Watson Asa Yea, I have been watching on instaflixxer for since november myself :)

  • @simplyanup9658
    @simplyanup9658 2 года назад

    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...😇

  • @blakestarling7657
    @blakestarling7657 8 лет назад

    Thanks a ton for these tutorials, you make learning programming simple and approachable :)

  • @atangakalunga8391
    @atangakalunga8391 2 года назад

    Thanks alot this my first time using the Rstudio and your videos are really helpful.

  • @daanburgering2462
    @daanburgering2462 6 лет назад

    Thanks Bucky!!
    This is a new program for me and your tutorials really help me!!
    Keep it up!!

  • @AnandSingh-qx7wl
    @AnandSingh-qx7wl 3 года назад

    Thanks. It worked in 2021

  • @BonJoviFan13
    @BonJoviFan13 9 лет назад +7

    Wheres the link for the csv file? :(

  • @laxithirani9910
    @laxithirani9910 4 года назад

    This Video really helped me do my project. Thanks!!

  • @asqn007
    @asqn007 10 лет назад

    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! :)

  • @nicolasnicolas274
    @nicolasnicolas274 7 лет назад

    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!

  • @jasmines5703
    @jasmines5703 8 лет назад +5

    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

    • @SumanthLazarus
      @SumanthLazarus 7 лет назад

      Yo, make sure you type the full name of file and extension inside the inverted commas.
      eg: "tuna.csv"
      Try now!

    • @Altario0508
      @Altario0508 7 лет назад +1

      I did type the extension and everything, but I continue to get the same error message

    • @pulkit1707
      @pulkit1707 6 лет назад

      write file extension also

  • @edGoldi
    @edGoldi 7 лет назад

    hey man just wanted to share my gratitude!

  • @davecreighton1162
    @davecreighton1162 5 лет назад

    Thanks for all your help. This was a great video

  • @matthewdonovan40
    @matthewdonovan40 9 лет назад +13

    No link for the csv file =/

  • @bruceb85
    @bruceb85 7 лет назад +1

    First time with R going through your videos. How do you all remember all these commands and stuff?

  • @miguelrodriguez-qc2uf
    @miguelrodriguez-qc2uf Месяц назад

    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?

  • @NEHASHARMA-qz2oi
    @NEHASHARMA-qz2oi 4 года назад

    Great video man, helped me a lot.

  • @redberry8049
    @redberry8049 7 лет назад

    your tutorials are amazing!

  • @naisonmandigo4135
    @naisonmandigo4135 8 лет назад

    bro you are heavy...thank you so much

  • @darkdevil905
    @darkdevil905 10 лет назад +5

    Hey bucky what happened ?

    • @ecceaufx3207
      @ecceaufx3207 10 лет назад +6

      Yeh I was really looking forward to more.

  • @gregorbecker1963
    @gregorbecker1963 3 года назад

    Thank you, great Video

  • @terraflops
    @terraflops 8 лет назад +6

    R did not grab the info, I followed your instructions (using a mac), the file was in my documents.

    • @johannanderson848
      @johannanderson848 4 года назад

      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!!

    • @hetaeramancer
      @hetaeramancer Год назад

      don't use mac lol

  • @loxleymoon
    @loxleymoon 2 года назад +1

    Hi, there's no link to Google Drive.

    • @loxleymoon
      @loxleymoon 2 года назад +1

      docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0
      Thanks to Tushar that posted this earlier in the comments.

  • @davidsweeney111
    @davidsweeney111 10 лет назад

    Hey Bucky when are we going to get the other videos about stats and graphs and all that good stuff ;)

  • @pheaktra97
    @pheaktra97 7 лет назад

    Nice tutorial.! Please will make "Hadoop Tutorial".

  • @nabeelahmad5271
    @nabeelahmad5271 3 года назад

    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 ☺️

  • @doc4085
    @doc4085 2 года назад

    Thankyou so much!

  • @TobiasDettinger
    @TobiasDettinger 7 лет назад

    first error: more columns than column names.
    second error file not foind, i had in in my Documents.

  • @Robson-dh3un
    @Robson-dh3un 3 года назад

    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!

  • @wenyichu3486
    @wenyichu3486 6 лет назад

    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.

  • @jpsantiago2839
    @jpsantiago2839 6 лет назад

    it would be nice if you zoomed in so that we can see the script

  • @michaelguzman4136
    @michaelguzman4136 5 лет назад

    the getwd doesnt even work for me it says function then internal getwd, I hate this thing

  • @andymackay3866
    @andymackay3866 2 года назад

    thank you. just, thank you :)

  • @michaelburton8024
    @michaelburton8024 3 года назад

    Bucky, what if the csv sits behind a login and password, say SmartSheets? How can this be done? Thank you

  • @uncleroq
    @uncleroq 5 лет назад

    there is no link in description

  • @nicholassanichar5307
    @nicholassanichar5307 3 года назад

    Life saver 😎 👍🏼

  • @esterbenites6902
    @esterbenites6902 4 года назад

    love you!!!!!!! it worked.... OMG

  • @rashmimalhotra123
    @rashmimalhotra123 8 лет назад

    How can we set the path .....setwd()..getting error in Mac

  • @edenbuke9203
    @edenbuke9203 9 лет назад

    Hi Bucky, can you give as some tutor on matlab; specially on image processing using matlab.

  • @KatherineCarpio-s5c
    @KatherineCarpio-s5c 6 месяцев назад

    Where is the google file?

  • @GOURABDASGUPTAinnovation
    @GOURABDASGUPTAinnovation 8 лет назад

    Here's a linear regression of the CSV file that used in this tutorial:
    ------------------------------------------------------------------------
    csvFile

  • @myprivate5383
    @myprivate5383 3 года назад

    Finally, I found Bucky...............

  • @ugyennorbu9443
    @ugyennorbu9443 6 лет назад

    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?

    • @shirazthe1
      @shirazthe1 5 лет назад

      Could you Please guide me how you have downloaded the file .

  • @yolandasimmons402
    @yolandasimmons402 5 лет назад

    I watched every video in order and was with you up until this tutorial. I don't think this works with MAC

  • @techonjupiter2849
    @techonjupiter2849 2 года назад

    Hi, bro. where's your .csv downloadable link?

  • @wolfgangstratocaster
    @wolfgangstratocaster 5 лет назад

    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

  • @Akash_S_S
    @Akash_S_S 3 года назад

    Where is CSV file link??

  • @jimmygoh42
    @jimmygoh42 6 лет назад

    how to print attributes/header only

  • @blox6137
    @blox6137 10 лет назад

    Bucky, can you teach us Lua? Several games use this scripting language such as Gmod, and ROBLOX, and apparently Dont Starve. so does WoW.

  • @salaramirkabirirazain8047
    @salaramirkabirirazain8047 4 года назад

    No link to data set, Please add

  • @zakariasediki3086
    @zakariasediki3086 10 лет назад

    hey bucky, can you please upload more videos, i can't wait.

  • @dan-simi6
    @dan-simi6 6 лет назад

    where is the link for csv file ?

  • @chaparro1097
    @chaparro1097 6 лет назад

    James Buchanan Barnes?

  • @mathiasror
    @mathiasror 10 лет назад

    Values Bucky, comma separated values.

  • @scottre3220
    @scottre3220 10 лет назад

    Hey Bucky, great series but you stopped when it started to get interesting (plotting).

  • @abirsonet925
    @abirsonet925 7 месяцев назад

    informative

  • @shineulagu8879
    @shineulagu8879 7 лет назад

    useful keep it up

  • @methodkid93
    @methodkid93 7 лет назад +3

    Here's the link to the data for the second csv file:
    samplecsvs.s3.amazonaws.com/Sacramentorealestatetransactions.csv

    • @johnhechtlinger9465
      @johnhechtlinger9465 6 лет назад

      where's the link for the FIRST FILE

    • @meredithprice6453
      @meredithprice6453 6 лет назад +1

      docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0

  • @rajaschavan7716
    @rajaschavan7716 5 лет назад

    where is the link

  • @jainishah8734
    @jainishah8734 6 лет назад

    it is what it is

  • @incometech8888
    @incometech8888 7 лет назад

    excellent

  • @pels7432
    @pels7432 5 лет назад

    what does "tuna" mean?

    • @warrior_1309
      @warrior_1309 5 лет назад

      It is a datatype where the .csv file is stored.

    • @prudencemwiti9767
      @prudencemwiti9767 5 лет назад

      @@warrior_1309 so its constant for all R users? or is there a specific way to create that datatype

    • @warrior_1309
      @warrior_1309 5 лет назад

      @@prudencemwiti9767 It is not constant. You can use any name to store a value.

    • @hetaeramancer
      @hetaeramancer Год назад

      it's a kind of fish

  • @Nothingimportant1
    @Nothingimportant1 Год назад

    thnaks man

  • @oscarsibanda9454
    @oscarsibanda9454 11 месяцев назад

    My man!!! 😂😂😂😂🎉🎉🎉

  • @Divyansh-Tiwari
    @Divyansh-Tiwari 4 года назад

    docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBymKDoqLLcKjPohtZkU/
    this is the link but the file doesn't exits so you cant do much form that.

  • @2580mia
    @2580mia 6 лет назад

    thank you

  • @brendansully12
    @brendansully12 6 лет назад

    R Programming Tutorial - 15 - How to Read CSV Files

    • @manan5309
      @manan5309 6 лет назад

      Brendan Sullivan ohh really? xD

  • @afzalhasan6494
    @afzalhasan6494 2 года назад

    thanku❤❤❤❤❤❤

  • @rajkumarjm
    @rajkumarjm 3 года назад

    comma separated values csv :D

  • @whitestork3896
    @whitestork3896 5 лет назад

    Comma Separated Values

  • @hnevko
    @hnevko 5 месяцев назад

    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)

  • @chirikihasini9a126
    @chirikihasini9a126 7 лет назад

    nice

  • @raphavelho7116
    @raphavelho7116 6 лет назад

    Guys, that's the link:
    docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0

  • @ChaosEmerald85
    @ChaosEmerald85 6 лет назад +1

    Spreadsheet link for anyone who needs it docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0

    • @Nothingimportant1
      @Nothingimportant1 Год назад

      After 5 years, I am commenting under your comment. Thank you.

  • @yazaaqa
    @yazaaqa 4 года назад +1

    Hi Guys,
    Kindly find the link :)
    docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU

  • @kithinga
    @kithinga 3 года назад

    😎😎

  • @rigelr5345
    @rigelr5345 5 лет назад

    Here you go: docs.google.com/spreadsheets/d/1BsfKB7S2ohsN4v_htUWZ3m4oBynKDoqLLcKjPohtZkU/edit#gid=0

  • @Badplum25
    @Badplum25 10 лет назад

    Mwahahaha time to hack clash of clans :p

  • @morskipaskenny
    @morskipaskenny 10 лет назад

    First! :D

    • @jailbreak889
      @jailbreak889 10 лет назад +3

      To die

    • @hrbharry
      @hrbharry 10 лет назад

      jailbreak889 slowly and painfully...

  • @lololxoxo3437
    @lololxoxo3437 5 лет назад

    VERY HELPFUL! THX!

  • @leonbeler2711
    @leonbeler2711 3 года назад

    Thank you so much!

  • @siddhft3001
    @siddhft3001 5 лет назад

    thank you bro!

  • @Caniballe
    @Caniballe 4 года назад

    Thanks a lot!