Mixing
Can't use geom_col to plot POSIXct object?
I have the dataset :
vec=c("1960-01-01 06:39:00","1960-01-01 05:10:00","1960-01-01 04:30:00","1960-01-01 02:53:00")
vec=as.POSIXct(vec, origin="1960-01-01", tz = "GMT")
dum=data.frame(v1=c("a","b","c","d"),v2=vec)
If I try to built a plot with a line, it works :
ggplot(dum, aes(y=v2, x=v1, group=1)) +
geom_line(colour="#59AA46")
But what I need is to built a barplot, so I use the following code which does not work so well :
ggplot(dum, aes(y=v2, x=v1)) +
geom_col(fill="#59AA46")
What am I doing wrong ?
r ggplot2 geom-col
edited Jan 2 at 15:32
Tjebo
2,5651531
asked Jan 2 at 13:06
DoeDoe
32
add a comment |
I have the dataset :
vec=c("1960-01-01 06:39:00","1960-01-01 05:10:00","1960-01-01 04:30:00","1960-01-01 02:53:00")
vec=as.POSIXct(vec, origin="1960-01-01", tz = "GMT")
dum=data.frame(v1=c("a","b","c","d"),v2=vec)
If I try to built a plot with a line, it works :
ggplot(dum, aes(y=v2, x=v1, group=1)) +
geom_line(colour="#59AA46")
But what I need is to built a barplot, so I use the following code which does not work so well :
ggplot(dum, aes(y=v2, x=v1)) +
geom_col(fill="#59AA46")
What am I doing wrong ?
r ggplot2 geom-col
edited Jan 2 at 15:32
Tjebo
2,5651531
asked Jan 2 at 13:06
DoeDoe
32
add a comment |
I have the dataset :
vec=c("1960-01-01 06:39:00","1960-01-01 05:10:00","1960-01-01 04:30:00","1960-01-01 02:53:00")
vec=as.POSIXct(vec, origin="1960-01-01", tz = "GMT")
dum=data.frame(v1=c("a","b","c","d"),v2=vec)
If I try to built a plot with a line, it works :
ggplot(dum, aes(y=v2, x=v1, group=1)) +
geom_line(colour="#59AA46")
But what I need is to built a barplot, so I use the following code which does not work so well :
ggplot(dum, aes(y=v2, x=v1)) +
geom_col(fill="#59AA46")
What am I doing wrong ?
r ggplot2 geom-col
edited Jan 2 at 15:32
Tjebo
2,5651531
asked Jan 2 at 13:06
DoeDoe
32
I have the dataset :
vec=c("1960-01-01 06:39:00","1960-01-01 05:10:00","1960-01-01 04:30:00","1960-01-01 02:53:00")
vec=as.POSIXct(vec, origin="1960-01-01", tz = "GMT")
dum=data.frame(v1=c("a","b","c","d"),v2=vec)
If I try to built a plot with a line, it works :
ggplot(dum, aes(y=v2, x=v1, group=1)) +
geom_line(colour="#59AA46")
But what I need is to built a barplot, so I use the following code which does not work so well :
ggplot(dum, aes(y=v2, x=v1)) +
geom_col(fill="#59AA46")
What am I doing wrong ?
r ggplot2 geom-col
r ggplot2 geom-col
edited Jan 2 at 15:32
Tjebo
2,5651531
asked Jan 2 at 13:06
DoeDoe
32
edited Jan 2 at 15:32
Tjebo
2,5651531
asked Jan 2 at 13:06
DoeDoe
32
edited Jan 2 at 15:32
Tjebo
2,5651531
edited Jan 2 at 15:32
Tjebo
2,5651531
edited Jan 2 at 15:32
Tjebo
2,5651531
2,5651531
asked Jan 2 at 13:06
DoeDoe
32
asked Jan 2 at 13:06
DoeDoe
32
asked Jan 2 at 13:06
DoeDoe
32
32
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The thing is ggplot will use unix time for the axis (which is by default the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT)).
In your data the date goes back to the year 1960 which means values on the y-axis are not only negative, but they are also all below 13e+6 (number of seconds in a year).
Since geom_line or geom_point will only take these values into consideration, this fact will not cause any issue when plotting, however geom_col or geom_bar will code for each bar the start and end value and in your case it will always start at point 0 (i.e. 1970-01-01 00:00:00) and end at some point sligtly lower than 31e+6 (i.e. 1960-01-01 H:M:S).
One workaround you can do is to use unix time and the play around with the layout until you get the output you want
Here is what I mean:
# define the y-axis limits
start_lim <- as.integer(as.POSIXct("1960-01-01 00:00:00", tz = "GMT"))
end_lim <- as.integer(as.POSIXct("1960-01-02 00:00:00", tz = "GMT"))
# plot
ggplot(dum, aes(x=v1, y=as.integer(v2))) + # use v2 as integer
geom_col(fill="#59AA46") +
coord_cartesian(ylim = c(start_lim, end_lim)) + # set the y limits
scale_y_reverse(breaks = as.integer(vec), # reverse the y axis
labels = vec) + # set the labels and ticks as wanted
ylab('Date-time') # set the axis title
I eventually got this :
answered Jan 2 at 15:31
DS_UNIDS_UNI
1,3921613
1
Thank you for your answer ! Thanks to your explanation, I simply chose to change my dataset so that my data have a different date (origin="1970-01-01").
– Doe
Jan 2 at 15:51
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54006916%2fcant-use-geom-col-to-plot-posixct-object%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The thing is ggplot will use unix time for the axis (which is by default the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT)).
In your data the date goes back to the year 1960 which means values on the y-axis are not only negative, but they are also all below 13e+6 (number of seconds in a year).
Since geom_line or geom_point will only take these values into consideration, this fact will not cause any issue when plotting, however geom_col or geom_bar will code for each bar the start and end value and in your case it will always start at point 0 (i.e. 1970-01-01 00:00:00) and end at some point sligtly lower than 31e+6 (i.e. 1960-01-01 H:M:S).
One workaround you can do is to use unix time and the play around with the layout until you get the output you want
Here is what I mean:
# define the y-axis limits
start_lim <- as.integer(as.POSIXct("1960-01-01 00:00:00", tz = "GMT"))
end_lim <- as.integer(as.POSIXct("1960-01-02 00:00:00", tz = "GMT"))
# plot
ggplot(dum, aes(x=v1, y=as.integer(v2))) + # use v2 as integer
geom_col(fill="#59AA46") +
coord_cartesian(ylim = c(start_lim, end_lim)) + # set the y limits
scale_y_reverse(breaks = as.integer(vec), # reverse the y axis
labels = vec) + # set the labels and ticks as wanted
ylab('Date-time') # set the axis title
I eventually got this :
answered Jan 2 at 15:31
DS_UNIDS_UNI
1,3921613
1
Thank you for your answer ! Thanks to your explanation, I simply chose to change my dataset so that my data have a different date (origin="1970-01-01").
– Doe
Jan 2 at 15:51
add a comment |
The thing is ggplot will use unix time for the axis (which is by default the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT)).
In your data the date goes back to the year 1960 which means values on the y-axis are not only negative, but they are also all below 13e+6 (number of seconds in a year).
Since geom_line or geom_point will only take these values into consideration, this fact will not cause any issue when plotting, however geom_col or geom_bar will code for each bar the start and end value and in your case it will always start at point 0 (i.e. 1970-01-01 00:00:00) and end at some point sligtly lower than 31e+6 (i.e. 1960-01-01 H:M:S).
One workaround you can do is to use unix time and the play around with the layout until you get the output you want
Here is what I mean:
# define the y-axis limits
start_lim <- as.integer(as.POSIXct("1960-01-01 00:00:00", tz = "GMT"))
end_lim <- as.integer(as.POSIXct("1960-01-02 00:00:00", tz = "GMT"))
# plot
ggplot(dum, aes(x=v1, y=as.integer(v2))) + # use v2 as integer
geom_col(fill="#59AA46") +
coord_cartesian(ylim = c(start_lim, end_lim)) + # set the y limits
scale_y_reverse(breaks = as.integer(vec), # reverse the y axis
labels = vec) + # set the labels and ticks as wanted
ylab('Date-time') # set the axis title
I eventually got this :
answered Jan 2 at 15:31
DS_UNIDS_UNI
1,3921613
1
Thank you for your answer ! Thanks to your explanation, I simply chose to change my dataset so that my data have a different date (origin="1970-01-01").
– Doe
Jan 2 at 15:51
add a comment |
The thing is ggplot will use unix time for the axis (which is by default the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT)).
In your data the date goes back to the year 1960 which means values on the y-axis are not only negative, but they are also all below 13e+6 (number of seconds in a year).
Since geom_line or geom_point will only take these values into consideration, this fact will not cause any issue when plotting, however geom_col or geom_bar will code for each bar the start and end value and in your case it will always start at point 0 (i.e. 1970-01-01 00:00:00) and end at some point sligtly lower than 31e+6 (i.e. 1960-01-01 H:M:S).
One workaround you can do is to use unix time and the play around with the layout until you get the output you want
Here is what I mean:
# define the y-axis limits
start_lim <- as.integer(as.POSIXct("1960-01-01 00:00:00", tz = "GMT"))
end_lim <- as.integer(as.POSIXct("1960-01-02 00:00:00", tz = "GMT"))
# plot
ggplot(dum, aes(x=v1, y=as.integer(v2))) + # use v2 as integer
geom_col(fill="#59AA46") +
coord_cartesian(ylim = c(start_lim, end_lim)) + # set the y limits
scale_y_reverse(breaks = as.integer(vec), # reverse the y axis
labels = vec) + # set the labels and ticks as wanted
ylab('Date-time') # set the axis title
I eventually got this :
answered Jan 2 at 15:31
DS_UNIDS_UNI
1,3921613
The thing is ggplot will use unix time for the axis (which is by default the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT)).
In your data the date goes back to the year 1960 which means values on the y-axis are not only negative, but they are also all below 13e+6 (number of seconds in a year).
Since geom_line or geom_point will only take these values into consideration, this fact will not cause any issue when plotting, however geom_col or geom_bar will code for each bar the start and end value and in your case it will always start at point 0 (i.e. 1970-01-01 00:00:00) and end at some point sligtly lower than 31e+6 (i.e. 1960-01-01 H:M:S).
One workaround you can do is to use unix time and the play around with the layout until you get the output you want
Here is what I mean:
# define the y-axis limits
start_lim <- as.integer(as.POSIXct("1960-01-01 00:00:00", tz = "GMT"))
end_lim <- as.integer(as.POSIXct("1960-01-02 00:00:00", tz = "GMT"))
# plot
ggplot(dum, aes(x=v1, y=as.integer(v2))) + # use v2 as integer
geom_col(fill="#59AA46") +
coord_cartesian(ylim = c(start_lim, end_lim)) + # set the y limits
scale_y_reverse(breaks = as.integer(vec), # reverse the y axis
labels = vec) + # set the labels and ticks as wanted
ylab('Date-time') # set the axis title
I eventually got this :
answered Jan 2 at 15:31
DS_UNIDS_UNI
1,3921613
edited Jan 2 at 15:52
answered Jan 2 at 15:31
DS_UNIDS_UNI
1,3921613
answered Jan 2 at 15:31
DS_UNIDS_UNI
1,3921613
answered Jan 2 at 15:31
DS_UNIDS_UNI
1,3921613
1,3921613
1
Thank you for your answer ! Thanks to your explanation, I simply chose to change my dataset so that my data have a different date (origin="1970-01-01").
– Doe
Jan 2 at 15:51
add a comment |
1
Thank you for your answer ! Thanks to your explanation, I simply chose to change my dataset so that my data have a different date (origin="1970-01-01").
– Doe
Jan 2 at 15:51
1
1
Thank you for your answer ! Thanks to your explanation, I simply chose to change my dataset so that my data have a different date (origin="1970-01-01").
– Doe
Jan 2 at 15:51
Thank you for your answer ! Thanks to your explanation, I simply chose to change my dataset so that my data have a different date (origin="1970-01-01").
– Doe
Jan 2 at 15:51
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54006916%2fcant-use-geom-col-to-plot-posixct-object%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
