Statistics for everyone: ch.35 Uploading your data

easier R than SPSS with Rcmdr : Contents

ch.35 Uploading your data

So far, we’ve done some analysis using example data. Now you should be able to upload your own data for analysis.

You can load ‘R data’ as shown above, with extensions such as ‘RData’, ‘rda ‘, etc.

In general, the data we have is often organized in Excel and is not of the R data type.

Once you’ve cleaned up the data in Excel, copy the parts that need analysis.

Let’s load the copied data immediately.

Write the temporary name to the red square part. Note the red and green arrow.

If you read the imported data, you will see that in well. Now you just have to apply the different methods you learned earlier.

If you select ‘commas’,

You will get a strange shape.

Of the many datasets, only one is active, and you can change that.

In a simpler way, select and copy the part you want in Excel, then hover over the above sentence in RGui and click the third icon at the top of the menu. Then the new data has now entered the data named df.

In the same way, you can set this data named ‘df’ as an active set and work with it.

At first, clicking with the mouse may feel comfortable, but if you know how the script works and use it occasionally, there will come a time when this will feel more convenient.

If you want to save it, save it as R data.

R data is not readable from Excel, so let’s do an export.

Be sure to change the settings window to the same as the red box on the right. Sometimes you need to enable write row name.

If you then save it as a CSV, it will read well in Excel as well.

There are other menus to read from various forms of data. In my case, as I do now, I only use the data in Excel to browse and then save and load only the parts I want to the clipboard. It’s because it’s very convenient. There are various functions in Excel, cells that have been typed and erased, etc., so it is easy to specify and load them in a clipboard way, and it seems that there will be no mistakes. If you want to take full advantage of the convenience of Excel while at the same time utilizing Rcmdr, the clappboard method is the most advisable.

easier R than SPSS with Rcmdr : Contents

=================================================