Data frames in R - Exporting data in R

Key Takeaways

hi and welcome back to our for statistics and data science in this lesson we will go full circle and complete the stellar saga of importing and exporting data in R so we have our data we have done some manipulations and we want to share our work with others through Dropbox on a flash drive preferably without giving our whole computer away to save your data into a shareable CSV file you use write dot CSV with write dot CSV - version for those of us who use a comma to denote a decimal and to save data into a tab delimited text document you use write that table let's export our Star Wars data from the first lesson on data frames and they sect what's happening if you need to recreate it I have put the code right here so you can pause and copy it obviously the first argument we pass is the data we want saved then we specify what the filename of our data should be once saved it does not have to be identical to the name of the data frame but be careful our is a little little Oh sometimes and for everything to work correctly and for your file to actually save in CSV format you will have to specify that by providing the extension dot CSV in the file name - ok ok finally and this is important the road names argument should be set to false in addition to literal R can be a little buggy sometimes if you save a file with the road names argument set to true it will add an extra column in the beginning of the table marking each row from 1 to n guessing that your actual first column is the names of the rows but wait you think that doesn't sound so bad yeah but it is because if you reopen the file you just saved our will somehow have forgotten it has saved it with this additional column that marks the row numbers and instead we'll consider the numbers to be part of your data and congratulations now you have a column you very much do not need repeat that a few more times and you will end up with n number of redundant columns and nothing to do with them in conclusion adding the row names argument and setting it to false is going to save you some unnecessary work okay I promised a short lesson and that was it thanks for watching everyone for more videos like this one please subscribe