<![CDATA[Easy Guides]]> https://www.sthda.com (C) 2005-2026 PHPBoost en PHPBoost <![CDATA[Import and export data]]> https://www.sthda.com/english/wiki/import-and-export-data https://www.sthda.com/english/wiki/import-and-export-data
What is RQuery?

RQuery has been created for beginners in R. It can also be useful to an advanced programmer in R.
This file contains a set of R functions to simplify your life in R programming

File formats for RQuery



Download an example of file format for RQuery: decathlon.txt


Files must be absolutely in *. txt tabulation

The decimal separator must be a dot and not a comma, for example (2.5). Please replace the commas with dots in your file.

No duplicates in row names and column names.

To avoid error :

  • Avoid column names beginning with a digit. Ex: use C1 instead of 1C
  • Avoid accented characters and spaces in row names and column names. Replace spaces with an 'underscore'. Ex: use 'voiture_renault' instead of 'Voiture renault'.



In general, the rows correspond to individuals or samples and the columns correspond to variables or parameters describing individuals (Ex: hair_colors, eye_colors).

If you still have problems to use RQuery please contact me at email address : mail_123soft@yahoo.fr

Importing and Exporting Data




Import data from a *. txt tabulation file format



Use the following R code :

Code R :
rquery.read_file&#40;&#41;


A GUI will appear asking you to indicate the file path to import.

The data are shown directly in R console.

To store the data in an R object, use :

Code R :
mydata<-rquery.read_file&#40;&#41;


To ensure that your data is stored in mydata, just type in the R console the name of your variable.

Code R :
mydata




Export data in a *. txt tabulation file format



The function is called rquery.write_file.
parameters:
mydata = the name of your variable to be exported.
file.name = the filename to save your dataset.

Code R :
rquery.write_file&#40;mydata, file.name="res.txt"&#41;


The file will be created in your working directory. To know your working directory, use the command getwd()

Code R :
getwd&#40;&#41;


The file is opened automatically by R after saving the file.]]> Sun, 22 Jul 2012 10:52:26 +0200 <![CDATA[Tutorials]]> https://www.sthda.com/english/wiki/tutorials https://www.sthda.com/english/wiki/tutorials Sat, 21 Jul 2012 21:43:21 +0200