All Questions
5,713
questions
1
vote
2
answers
45
views
data frame breakdown by year, rounding up by duration of each period
I have a data frame of county executives and the first and last years they served.
I am running a panel study with county-year as the unit of analysis. The date range is 2000 to 2009.
I will like to ...
- 381
1
vote
2
answers
36
views
dataframe breakdown by year
I have a dataset on county executives and their year of inaguration. I need break down which year each executive was inaugurated.
The problem is that the notation under the "year" variable ...
- 381
-2
votes
0
answers
31
views
Extract Month from time column 2024-06-30 [duplicate]
I have a data frame in using the R language with a "date" column YYYY-MM-DD and I want to extract the month and create a new column in my data frame named "month" with just the ...
1
vote
2
answers
64
views
getting the latest date for a a duplicated item in r [closed]
I have the following dataset (below).
I am trying to get the latest SEnd value for each individual tag (see Desired output) where I have the Tag, Owner and the latest SEnd date only. Essentially I am ...
- 105
0
votes
1
answer
30
views
How to mutate a year quarter str into date?
I have a df that comes from an api with a Trimestre (Código) column in string format:
pib$`Trimestre (Código)` <- c(199101,199102,199103,199104,199201,199202,...)
but i need to mutate this column ...
- 109
0
votes
1
answer
36
views
Count unique individuals in each month [duplicate]
I have a dataframe that looks something like this:
data.frame(
stringsAsFactors = FALSE,
species = c("species1","species1",
"species1",...
- 13.7k
1
vote
4
answers
54
views
Generate Sequence of Year-Quarter in R
I have a input dataset that is like this:
Name
Date
A
2018 Q2
A
2019 Q3
B
2018 Q4
B
2019 Q4
And my desired output looks like this:
Name
Date
A
2018 Q2
A
2018 Q3
A
2018 Q4
A
2019 Q1
A
2019 ...
- 13
0
votes
2
answers
54
views
Return the name of a column which matches a date value
I have a data.frame with about 66k rows and 150 columns. For the purposes of this question, this is a sample. All columns are date objects.
structure(list(fixed_date = structure(c(19267, 19239, 19120, ...
0
votes
3
answers
47
views
Transform X Year(s), Y Month(s), Z Day(s) into numeric in R
Looking to see if there is a decently easy way to turn a character data point similar to 8 year(s), 6 month(s) and 5 day(s) into a number value like 8.52 (or whatever the calculation is). I am trying ...
- 11
0
votes
2
answers
80
views
Column with number date and formatted dates (2020-10-03)
I have a lot of excel files that I read into R. I get new ones every month and they are similar but the column names or other things will change slightly. I have started just reading all the columns ...
0
votes
0
answers
22
views
Error Message: Caused by error in `c()`: Argument 67 is empty - despite the object not containing empty data [duplicate]
I am receiving the following error message: Error in mutate():
! Problem while computing CALL_RESPONSE_TIME = bizHrDiff(CALL_DATEADDED, CALL_RESPONSE).
Caused by error in c():
! argument 67 is empty
...
1
vote
2
answers
68
views
POSIX date formats
I am working under R and I have a date (format "2018-08-10") and a time (format "10:00:00"). Both are character strings. I need to calculate the beginning time of the event (time - ...
- 11
0
votes
1
answer
32
views
thermal sum between two dates, from a daily data frame
I have a data frame with daily temperature data. I would like to calculate the sum in several columns, between two dates from a second data frame and create a output (results) in a new data frame.The ...
- 195
0
votes
2
answers
38
views
Average and sum between two dates, from a daily data frame
I have a data frame with daily temperature data. I would like to calculate the average between two dates from a second data frame and add the results in a new column.
The average temperature must be ...
- 195
0
votes
2
answers
53
views
Filtering my data frame is erasing my data frame despite correct number of rows
I have a dataframe of transactions (roughly 76K rows). Each row has a column called START_DATE which is when the transaction started.
I am trying to filter down to transactions with START_DATE > 1/...
- 3