Posts by Filipaaaaa • 13 points

• -2

  votes

  3

  answers

  339

  views

  Q: How to convert the number of hours into date format in r

  I have a column in this format and I can’t convert it to date. At this time it is in hours. Example: 8.5 is actually 08:30:00 and so on... Any idea how to do it? (see image) start_date <-…

  r date

  asked 4 years, 9 months ago Filipaaaaa 13

• 0

  votes

  1

  answer

  33

  views

  A: Create a column with case_when with ranges error appears

  In fact, I managed to solve the problem this way: datanew1$Calendar_Week <- as.numeric(datanew1$Calendar_Week) datanew1$Quartile <- case_when( datanew1$Calendar_Week %in% seq(36,45) ~ "1",…

  array r syntax-error

  answered 4 years, 9 months ago Filipaaaaa 13

• -1

  votes

  1

  answer

  33

  views

  Q: Create a column with case_when with ranges error appears

  I have this database and I intend to create a new column with this structuring (see image). For example, if the row in the Calendar_week column has a value between 36 and 45 the new Quartile column…

  array r syntax-error

  asked 4 years, 9 months ago Filipaaaaa 13

• 0

  votes

  1

  answer

  31

  views

  Q: Query SQL Help

  select T.n_acid,T.marca from (select n_acid, veic_seguro, marca from marca_acid as ma, veiculo as v where ma.veic_seguro = v.n_veic) as T group by T.n_acid, T.marca; This query returns the table…

  sql postgresql query

  asked 5 years, 7 months ago Filipaaaaa 13

• 0

  votes

  1

  answer

  197

  views

  Q: Sort by year SQL data

  I have a table with 2 columns (one with date (YYYY,MM,DD) and another with a numeric value). I want the table to be ordered only per year and in case of entries with the same year the "tie-breaker"…

  sql date classification

  asked 5 years, 8 months ago Filipaaaaa 13