StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4844261
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-01-30T17:16:42.267
FavoriteCount
0
LastActivityDate
2017-10-25T10:57:50.563
LastEditDate
2017-10-25T10:57:50.563
LastEditorUserId
516548
OwnerUserId
516548
ParentId
4843969
PostTypeId
2
Score
42
ViewCount
0
LastEditorDisplayName
text
Body
1) Since the times are dates be sure to use <code>"Date"</code> class, not <code>"POSIXct"</code> or <code>"POSIXlt"</code>. See R News 4/1 for advice and try this where <code>Lines</code> is defined in the Note at the end. No packages are used here. <pre><code>dm <- read.table(text = Lines, header = TRUE) dm$Date <- as.Date(dm$Date, "%m/%d/%Y") plot(Visits ~ Date, dm, xaxt = "n", type = "l") axis(1, dm$Date, format(dm$Date, "%b %d"), cex.axis = .7) </code></pre> The use of <code>text = Lines</code> is just to keep the example self-contained and in reality it would be replaced with something like <code>"myfile.dat"</code> . (continued after image) <a href="https://i.stack.imgur.com/TmVLb.png" rel="noreferrer"><img src="https://i.stack.imgur.com/TmVLb.png" alt="screenshot"></a> 2) Since this is a time series you may wish to use a time series representation giving slightly simpler code: <pre><code>library(zoo) z <- read.zoo(text = Lines, header = TRUE, format = "%m/%d/%Y") plot(z, xaxt = "n") axis(1, dm$Date, format(dm$Date, "%b %d"), cex.axis = .7) </code></pre> Depending on what you want the plot to look like it may be sufficient just to use <code>plot(Visits ~ Date, dm)</code> in the first case or <code>plot(z)</code> in the second case suppressing the <code>axis</code> command entirely. Note: <pre><code>Lines <- "Date Visits 11/1/2010 696537 11/2/2010 718748 11/3/2010 799355 11/4/2010 805800 11/5/2010 701262 11/6/2010 531579 11/7/2010 690068 11/8/2010 756947 11/9/2010 718757 11/10/2010 701768 11/11/2010 820113 11/12/2010 645259" </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPlotting time-series with Date labels on x-axis
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USG. Grothendieck
UserOwnerUserId
1. USG. Grothendieck
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.