-
Notifications
You must be signed in to change notification settings - Fork 11
/
Copy path21_data_reading_fileformat.rmd
118 lines (49 loc) · 2.94 KB
/
21_data_reading_fileformat.rmd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
# How to Read Data {#dataread}
You've got some data, now you need to get it into your R environment.
## Introduction
## Databases
[Databases using R](https://db.rstudio.com/overview) -- from RStudio
John David Smith, Sophie Yang, M. Edward (Ed) Borasky, Jim Tyhurst, Scott Came, Mary Anne Thygesen, and Ian Frantz, 2020-01-27, [Exploring Enterprise Databases with R: A Tidyverse Approach](https://smithjd.github.io/sql-pet/)
[R database interfaces](http://www.burns-stat.com/r-database-interfaces/), Burns Statistics
***
## Labelled data
In particular, survey data
* Marta Kołczyńska, 2019-03-03, [Searchable codebook from labelled data in R](https://martakolczynska.com/post/codebook-labelled-data/)
## R readers
## `{readr}`
Alison Hill (2018-07-07-8) [Read Data with Multiple Header Rows into R](https://alison.rbind.io/post/2018-02-23-read-multiple-header-rows/)
### `{rio}`
**package**
CRAN page: _currently only development version_, see tidyverse link below
vignette: [Import, Export, and Convert Data Files](https://cran.r-project.org/package=rio/vignettes/rio.html)
### `{googledrive}`
**package**
CRAN page: _currently only development version_, see tidyverse link below
tidyverse page: [`googledrive`](https://tidyverse.github.io/googledrive/)
### `{foreign}`
**package**
CRAN page: [foreign: Read Data Stored by Minitab, S, SAS, SPSS, Stata, Systat, Weka, dBase, ...]( https://CRAN.R-project.org/package=foreign)
**articles**
* [How to open an SPSS file into R](http://www.milanor.net/blog/how-to-open-an-spss-file-into-r/), by Davide Massidda (2014-03-26)
### `{haven}`
**package**
**articles**
## PDF files
Luis D. Verde, 2018-12-14, [Tidyeval meets PDF table hell](http://luisdva.github.io/rstats/Tidyeval-pdf-hell/) -- great solution to the common problem of broken rows ("values that are broken up into two lines for whatever reason (often to optimize space on a page in a table in a typeset pdf)").
## Stata files
### `{read.dta}`
Reads a file in Stata version 5–12 binary format into a data frame.
CRAN page: [`read.dta`: Read Stata Binary Files](http://stat.ethz.ch/R-manual/R-devel/library/foreign/html/read.dta.html)
### `{readstata13}`
Function to read and write the 'Stata' file format.
CRAN Page: [readstata13: Import 'Stata' Data Files](readstata13: Import 'Stata' Data Files)
## Time series database files
### `{TSdbi}` and related packages
**package**
CRAN page: [TSdbi: Time Series Database Interface]( https://CRAN.R-project.org/package=TSdbi)
Note: {TSdbi} has some related extension packages:
* CRAN page: [TSdata: 'TSdbi' Illustration](https://cran.r-project.org/package=TSdata)
* This package gives an overview and usage examples for all the `TSdbi` family of packages
* CRAN page: [TSPostgreSQL: 'TSdbi' Extensions for 'PostgreSQL'](https://cran.r-project.org/package=TSPostgreSQL)
* CRAN page: [TSsdmx: 'TSdbi' Extension to Connect with 'SDMX'](https://cran.r-project.org/package=TSsdmx)
-30-