Based on the code and data below how can I replace values in the date column with new values using ifelse. Error: Warning message: Problem while computing `date = ifelse(…)`. ℹ longer object length is not a multiple of shorter object length Data and code: df = structure(list(id = c(1, 2, 3, 4, 5, 6,… Read More replace multiple values using ifelse

I am trying to visualize the top 3 or n bars in R in an order one after another. I have followed Question on stack overflow in which he did exactly the same what I want. In my dataset, I don’t have y-axis values where as desc() function requires one argument. I don’t know what… Read More Problem with visualizing top frequency Bar with desc() function

Based on the code and data below, the imap function converts every column name to 1. How can I use the following imap code in such a way that the column names don’t change? Code + Data: # Create a large dummy dataset df2 = data.frame(Year = 2022, Reference_Number = seq(1,6694), c = seq(1,6694), d… Read More extracting dataframes from list causes column name issue

How to rename column 5 through column 66 as x1:x62 with dplyr? Old names are arbitrary and without a pattern. >Solution : We can use rename_with library(dplyr) library(stringr) df1 %>% rename_with(~ str_c("x", seq_along(.x)), 5:66)

I have a data frame called year year pedal_cycles cars_and_taxis all_hgvs <int> <dbl> <dbl> <dbl> 1 1993 2489980831. 210084884699. 15071438165. 2 1994 2495693171. 214388644505. 15394423667. 3 1995 2573600860. 218175790767. 15810086788. 4 1996 2531689966. 223645671968. 16301368043. 5 1997 2536137453. 227296395346. 16686840160. I want to get ratios relative to the first row (year==1993), I used the following… Read More How to use loop or other codes to get a ratio by divided first row in R?

I have two factors, day and the other group. The value is how many totals in each group. x <- c(5,17,31,9,17,10,30,28,16,29,14,34) y <- c(1,2,3,4,5,6,7,8,9,10,11,12) day <- as.character (c ( 1,2,3,4,5,6,7,8,9,10,11,12) ) df1 <- data.frame(x, y, day) df2 <- reshape2::melt(df1, id.vars=’day’) colnames (df2)[2] = "group" > df2 day group value 1 1 x 5 2 2… Read More Getting value not found while running chisq_test using dplyr?

I am trying to filter a data frame using dplyr and I can’t really think of a way to achieve what I want. I have a data frame of the following form: A B C ———– 1 2 5 1 4 6 2 2 7 2 4 6 Each value in column A appears exactly… Read More R dplyr filter data based on values in other rows

I was wondering if there is a possibility to group data which is in weeks into months for simple consolidation. The data frame looks like: structure(list(c("PCE", "PCE", "PCE", "PCE", "PCE", "PCE"), c("3", "0", "0", "0", "0", "0"), c("2", "0", "0", "0", "0", "0"), c("4", "0", "0", "0", "0", "0"), c("5", "0", "0", "0", "0", "0"),… Read More Group Weeks in Columns into Months in Column in a Data Frame in R

I wanted to delete lines from a data frame based on multiple variables values. In my example below, I wanted to delete lines from March 2022 (and only them). This means that both of my conditions must be true (m = March AND Y = 2022) to have a kind of overall condition True. I… Read More Delete data frame lines with multiple variables values conditions R

I have a large dataset with unique values for individuals that have some repeats. Each of these repeated rows are important data that I need to keep. However, I want to assign a unique ID to each individual. Below is example raw data: pit let ret otherdata 19000 1 2 xx 19030 3 4 sy… Read More assigning unique value to new column based on multiple columns/rows