Exporting Data from R into a CSV File | Statistical Computing in R | STA636_Topic196

Do students in this module I will discuss with you how to export data from R into a CSP file. The first thing to note is that exporting data from R into a CSP file is the standard and most widely used way to describe the process of saving a data frame and a matrix into a comma- separated values ​​file. It's one of the most commonly used file formats for storing data. The CSV format. Alright. So now the next thing we'll do is why we'll do this. Why will we do this? Exporting data allows us to save data sets that have been created and modified in our library. So, they can be used in other software, such as Excel or other software. There are so many different types of software, and it can be shared with other users. Right, in order to demonstrate to you how to export data from R in the form of a CSV file, I'll be using one of the data sets that are built into R. So you know that there are so many data sets inside that as well. So I'm going to use one of them, one of the very famous ones, which I've already discussed with you in another module, and that is the empty cars data set. I have the data set in this slide, but I'd also like to demonstrate it to you one more time. How can you have a look at it in here? All you have to do is type in the name of that data set and I've typed in 'MT CARS' and I'm going to hit enter. You see, in a split second, you get the data set. It is, you know, the miles per gallon and all those other things pertaining to cars. Okay, you already know a lot about this. So I am not going to go into further details of this one. Now if we want to export this data set from R into a you know in the form of a CSV file then what will we do students when we were importing we wrote read.csv and now we will write write.csv just like that was a function similarly this is also a function so we write w write e dot csv open the bracket and close the bracket and then the same thing is that now something has to come inside that bracket also. So now you students have to note that for this function you need two arguments, not one but two. Now which are those arguments? The first one is the name of the data set. Obviously, you will write the name of the data set which you want to export. So that's that but what about the second argument. The second argument is the path of the location where we wish to store the CSV file. Ok? Earlier we were importing, right? Now we are exporting and we have to specify the location where we want to store the CSV file. Its path is alright, so we will go into some details about how we will do it. Suppose that we are wanting to store the CSV file containing the exported data. In the folder called Documents. Alright now in order to determine the path of the Documents folder you should open the folder and then you can right click on any file contained in that folder and then you click on properties. So let me demonstrate this to you. I will go to the Documents folder in My Computer. This is in front of you, I double clicked on the Documents folder and it opened. Now I will right click on any file. Suppose I choose the last one. And look, this entire list comes before us. The last one in that is properties. I just clicked on the last one and it appeared in front of you. Now I click somewhere else and on someone else. Right clicking on this one also gives me the same thing. All right. Now click on properties. That is a must. There you are. Now you see that you can see a location here. C double dot which is called colon. Back slush users back slush administrators back slush documents Allright Obviously, then this is the path. I want to keep my exported CSV file in the documents itself, so its path is already in front of you. But to insert that function inside it, we will have to do some similar work which we did while importing. So it is obvious that the path is C Users Administrator Documents. Where I want to place my exported file. You wanted to do it in the documents only, right? But now will we just put this inside our write CSV function, no you will not be able to do this because if you do this then an error will come. So what we suppose to do is the steps are quite similar to the steps that you had in the case of importing a function. A whose name was read dot csv. What now? Right Csp. So the first step is to replace the back slashes by forward slashes. You can see this. I changed it to what it was above, immediately after the c and the colon. Replacing the back slash with a forward slash then users did the same thing. And did the same thing after administrator. And the word documents is written after that. The second step is again similar to the one we had before. We will add a forward slash immediately after the Word document and we will then write the name of the data along with the dot cs extension. So what was the name of our data set? Empty cars. And you can see here on the slide that I put another forward slash after documents and then the name of the date and dot csb with it. So once you have got this students now it is okay except for one more step. Again, it 's similar to what you had before, and what that is, you're going to put double quotation marks a in the beginning and at the end because without that, it won't work. Alright now we are ready. Now we're ready to place this whole thing in the second argument of the right.cs function. So I have put this in front of you right dot c. So now we are ready to insert this into the right dot csv function. Alright let me show it to you. Then what we have is we have right dot csv and then the bracket opens and then the first argument is the name of the data set empty cards followed by a comma and after the comma this entire path which we have constructed we put it here and now I am going to copy this from my slide and I am going to paste it in R and let's see what happens. Look, earlier I had placed data empty cards in front of you. And now I am putting this function right below it here. All right. Even if God had done this, it would still have been the same thing. Even if you don't rub it, there is no issue. Alright students now that we have inserted this in are we still have to do anything else or is our work complete. We have written here right dot csv empty cards comma and path after it. Path of what? Where we want to place our CSP file. So let's see that Documents folder that I showed you earlier. You know you remember there was nothing there. So now let's see if this CSV file has arrived there or I still have to do something here after which it will arrive. So let me see. I'm minimizing my slides and now I'm in the Documents folder. And look at this students at the end of this list I C MT Cars dot CSP. So whatever I wanted has been accomplished. All I had to do was write that function and enter it and there was no error because I did not make any mistake in all those ah forward slashes and the inverted commas double quotation marks etcetera. And now let me open this and see if this is the same data or something else. So I'm opening it in front of you and there you are. You see, students, everything is fine. Ah the first column MPG just like you have in R, the second column sale and so on. So, this is how you would export data from R in the form of a CSP file. And students, that's it. I hope you have enjoyed. Lot of things that you have done in our time and I would like to encourage you to do a lot more. All the best.