StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2321512
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-02-23T20:35:59.533
FavoriteCount
0
LastActivityDate
2010-02-23T20:35:59.533
LastEditDate
LastEditorUserId
0
OwnerUserId
269831
ParentId
2321333
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
One can go directly into SQLITE using read.csv.sql() OR read.csv2.sql() from the sqldf package. From the online manual: <a href="http://code.google.com/p/sqldf/#Example_13._read.csv.sql_and_read.csv2.sql" rel="noreferrer">Link</a> <blockquote> Example 13. read.csv.sql and read.csv2.sql read.csv.sql is an interface to sqldf that works like read.csv in R except that it also provides an sql= argument and not all of the other arguments of read.csv are supported. It uses (1) SQLite's import facility via RSQLite to read the input file into a temporary disk-based SQLite database which is created on the fly. (2) Then it uses the provided SQL statement to read the table so created into R. As the first step imports the data directly into SQLite without going through R it can handle larger files than R itself can handle as long as the SQL statement filters it to a size that R can handle. Here is Example 6c redone using this facility: </blockquote> <pre><code># Example 13a. library(sqldf) write.table(iris, "iris.csv", sep = ",", quote = FALSE, row.names = FALSE) iris.csv <- read.csv.sql("iris.csv", sql = "select * from file where Sepal_Length > 5") # Example 13b. read.csv2.sql. Commas are decimals and ; is sep. library(sqldf) Lines <- "Sepal.Length;Sepal.Width;Petal.Length;Petal.Width;Species 5,1;3,5;1,4;0,2;setosa 4,9;3;1,4;0,2;setosa 4,7;3,2;1,3;0,2;setosa 4,6;3,1;1,5;0,2;setosa " cat(Lines, file = "iris2.csv") iris.csv2 <- read.csv2.sql("iris2.csv", sql = "select * from file where Sepal_Length > 5") </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to read in a text file to R using textConnection and library(sqldf)
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJay
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.