posixct Questions
2
Solved
I spent some time trying to figure out why the hour ticks were shifted when scale_x_datetime was applied. I've tried to give the timezone when the Date/Time column was created. I used ggplot and sc...
1
Solved
I am trying to make a graph with "time markers". These time markers are vertical lines for certain dates. Time data are POSIXct format. I would like to use the awesome interactive interface of Plot...
Bonaventure asked 10/10, 2018 at 7:38
4
Solved
I have a character datetime column in a file. I load the file (into a data.table) and do things that require the column to be converted to POSIXct. I then need to write the POSIXct value back to fi...
2
Solved
I have found a very annoying problem that I want to share with the community. This is a question that I have found an acceptable solution for (detailed below), but I now have several follow-up ques...
3
Solved
I have an instrument that exports data in an unruly time format. I need to combine the date and time vectors into a new datetime vector in the following POSIXct format: %Y-%m-%d %H:%M:%S. Out of cu...
Cachexia asked 17/4, 2017 at 22:1
5
Solved
I want to convert a numeric variable to POSIXct using anytime. My issue is that anytime(<numeric>) converts the input variable as well - I want to keep it.
Simple example:
library(anytime)
...
1
Solved
I have a dataframe with dates and I am trying to convert it to a POSIXct object but I am unable to specify timezone. Any idea why this is happening?
> str(dates)
'data.frame': 3171 obs. of 3 va...
2
Solved
I have data with stock prices(data). Stock data I would like to visualize it. I first use ggplot R plotting to visualize the series.
Date Closed
2010-07-19 0.0808
2010-07-20 0.7547
When I used...
Batho asked 29/1, 2018 at 19:48
1
This snippet
options(digits.secs=3)
s<-"12:00:00.188"
fmt<-"%I:%M:%OS"
print(strptime(s,fmt))
print(as.POSIXct(strptime(s,fmt)))
gives this textual output:
[1] "2017-09-12 00:00:00.188 CE...
1
I am trying to expand the amount of factors shown in one custom Posixct field where the normal way (str(DF, list.len=ncol(DF), vec.len=20)) does not work.
I request here 20 but it shows all the ti...
1
Solved
I am not sure what is going wrong with selecting date times as a POSIXct format. I have read several comments on subsetting a dataframe based on as.Date and I can get that to work without an issue....
1
Solved
I want to scatterplot a numeric vector versus daytime (%H:%M) in ggplot2.
I understand that
as.POSIXct(dat$daytime, format = "%H:%M")
is the way to go in terms of formatting my timedata, but th...
2
Solved
I want to decompose hourly time series with decompose, ets, or stl or whatever function. Here is an example code and its output:
require(xts)
require(forecast)
time_index1 <- seq(from = as.POSI...
1
Solved
Why doesn't the colClasses argument to data.table::fread seem to convert the REQUEST_DATE column to POSIXct in the example below? It converts the ROW_ID column without issue.
library(data.table)
...
Clearness asked 27/1, 2017 at 21:25
2
Solved
I am using ROracle within R to access an Oracle database.
I noticed that probably since the summer-time change, any DATE (datetime) Oracle column are now converted wrongly (I get an hour LESS in ...
1
Solved
I have a list redDressTweets of statuses. status is a class with a field created. I am trying to form a list of times in which tweets were posted. Here is how I'm trying to do it
times <- unlis...
1
Solved
I am trying to plot a time series that has an x axis of class "POSIXct" using ggplot2, which is working up to a point.
When I try to manipulate the x axis breaks and labels using scale_x_dat...
0
I was struggling that read.csv with colClasses containing POSIXct was rounding up entire timestamps column down to date dropping time part. I came across a similar question suggesting that some dat...
2
I have a large dataframe of dates in PosixCt format. My objective is simple: to change all of the dates to one day - 2016-05-01 - while keeping all of the times the same. How would I proceed to rep...
3
Solved
I have a POSIXct object and would like to change it's tz attribute WITHOUT R to interpret it (interpret it would mean to change how the datetime is displayed on the screen).
Some background: I am...
0
I have a function like so:
foo = function(time_in){
# code here that changes POSIXct to numeric
time_out = as.POSIXct(time_in, origin = '1970-01-01')
}
where the user enters time_in as a POSIX...
2
Solved
I have a dataframe, df, which has factor variable for date in the following format:
2015-12-15 10:00:00
2015-12-19 12:00:00
2015-12-20 20:00:00
It is hourly data. The problem arises when looking...
3
Solved
I have a data.table (~30 million rows) consisting of a datetime column in POSIXct format, an id column and a few other columns (in the example, I just left one irrelevant column x to demonstrate th...
Barfly asked 28/4, 2016 at 14:48
1
Solved
I have two columns of PosixLT times with no NA values , yet NA values show up upon check
> sum(is.na(check$start))
[1] 19
> sum(is.na(check$end))
[1] 23
The data is present in the cells, ...
1
Solved
For datetimes fasttime provides very fast parsing to POSIXct
library('fasttime')
library('lubridate')
library('microbenchmark')
# parse character to POSIXct
Sys.setenv(TZ='UTC')
test <- rep('2...
© 2022 - 2024 — McMap. All rights reserved.