R CODER

IMPORT AND EXPORT DATA IN R

R offers versatile functions and packages like readr, readxl, and foreign for importing data from formats like TXT, CSV, Excel, databases and to export them

IMPORT DATA

Importing data allows loading different data sets into R from external files, such as TXT, CSV, XLS, XLSX and even reading databases or the content of web pages

Learn how to read TXT files in R programming language with read.table function

Read TXT

read.table() read.delim() read.delim2()

Learn how to read CSV files in R

Read CSV

read.csv() read.csv2()

Read Excel file sheets into R

Read Excel files (XLS and XLSX)

readxl openxlsx xlsx XLConnect

Read SQL databases in R

Read SQL databases

DBI dbConnect() dbReadTable() dbWriteTable() dbListTables() dbListFields() dbSendQuery() dbDisconnect()

Web scraping in R

Web scraping with rvest

rvest read_html() html_element() html_text2() html_elements() html_attr() html_attrs() html_table()

EXPORT DATA

Data export allows you to store analysis results in files that can be shared or used in other environments

Learn how to export data in R, as CSV, TXT, Excel, among other formats

Export data to TXT

write.table()

Learn how to export data in R, as CSV, TXT, Excel, among other formats

Export data to CSV

write.csv() write.csv2()

Learn how to export data in R, as CSV, TXT, Excel, among other formats

Export data to Excel (XLS and XLSX)

write.xlsx() write.xlsx2()

Learn how to export data in R, as CSV, TXT, Excel, among other formats

Export data to SPSS

foreign write.dta()

Learn how to export data in R, as CSV, TXT, Excel, among other formats

Export data to STATA

foreign write.dta()

Learn how to export data in R, as CSV, TXT, Excel, among other formats

Export data to XML

kulife write.xml()