Advertisements I attempted to extract gender information from the first name using gender package in R. I tried both ‘ssa’ and ‘genderize’ for argument method. Here is my demo sample code. unique_id <- seq(0:6) first_name <- c("annie j", "Juan", "Richard", "Aj", "Dana", "annie j", "liyuan") demo1 <- as.data.frame(cbind(unique_id, first_name)) For ssa, it uses names based… Read More Fail to extract the gender information from the first name in R

Advertisements I have a data frame that looks like this: df <- as.data.frame(rbind(">A1", "aaaa", "bbb", "cccc", ">B2", "dddd", "eeeee","ff", ">C3", "ggggggg", "hhhhh", "iiiii", "jjjjj")) This is what I want to get: df1 <- as.data.frame(rbind(">A1", "aaaabbbcccc", ">B2", "ddddeeeeeff", ">C3", "ggggggghhhhhiiiiijjjjj")) As you can see, I want to merge every row between two rows that contain a… Read More Merge rows if previous row contains a string that starts with a particular sign

Advertisements I have a dataset that looks like this: > dput(df) structure(list(Car = c("Mazda", "Mazda", "Mazda", "Mazda", "Mazda", "Mazda", "Lexus"), Date = c("2/20/20", "2/21/20", "2/22/20", "2/23/20", "2/24/20", "2/25/20", "9/3/20")), class = "data.frame", row.names = c(NA, -7L)) I would only like to filter the Dates where the Car=="Mazda". In this scenerio, I would like to remove… Read More Filter dataset by values IF column contains certain string

Advertisements Good day, I’m trying to figure out how to rename columns in R based on a certain set of conditions. Consider the following two examples from the code, tt <- t(matrix(c(.8,.2,0))) colnames(tt) <- c("2","3","NA") tt tt <- t(matrix(c(.7,.3,0))) colnames(tt) <- c("1","3", "NA") tt Which generate the following two outputs respectively, I want to rename… Read More Conditional naming of columns in R

Advertisements I’m looking at writing an R function that operates on each row of a dataframe. The function needs to perform an adjustment calculation on a measurement column that corresponds to mass/volume of a food or drink where the adjustment calculation differs depending on if it’s a food or a drink, and if it’s a… Read More Conditionally running a function on a row based on values in another column using a function

Advertisements I have a list of data frames contained in a large list object of R. In each data frame of the list I have latitude and longitude columns. I want to subset all the data frames in contained the list to certain latitude and longitude coordinates. How can I don this in R? I… Read More Subset across multiple data frames contained in a large list object of R

Advertisements I have a toy dataframe df with 2 columns of class integer and factor. However, when I tried to check whether a column is factor, I got incorrect result as follows num <- c(1:5) fac <- factor(letters[1:5]) df <- data.frame(num, fac) df # num fac 1 1 a 2 2 b 3 3 c… Read More Check for class of columns in dataframe

Advertisements I have a dataframe such as the following: ID country region 1 32 32001 2 32 1001 3 68 68001 4 214 19017 5 214 214017 All variables are character, despite being integers. I am cleaning the data and need all of the region variable to be the same. However, due to a clerical… Read More Conditionally replace first character (or first two) of a column with value from that row's other column (R)

Advertisements I have two dataframes that look like this: > dput(df) structure(list(first_column = c("value_1", "value_2"), second_column = c("value_1", "value_2")), class = "data.frame", row.names = c(NA, -2L)) > dput(df_new) structure(list(first_column = c("value_1", "value_2"), second_column = c("value_1", "value_2"), third_column = c("value_1", "value_2")), class = "data.frame", row.names = c(NA, -2L)) I would like to match the df_new dataframe… Read More Delete columns in R that do not match another dataframe

Advertisements I have a dataframe with a column named "Start" which has dates formatted as "m/d/yyyy" which I want to use to create a new column with just "m/yyyy". I have looked at other questions here but most don’t follow this exact format and solutions haven’t worked for this. Here is an example of the… Read More Extract month and year while ignoring day from column in R