Advertisements Below is the code to generate the dataframe for demonstration: d<-data.frame(x1=c(rep("no",5),rep("yes",4),rep("no",2),rep("yes",3),rep("no",2),rep("yes",3)), x2=c(rep("no",6),rep("yes",1),rep("no",9),rep("yes",2),rep("no",1)), dummy=c(rep(0,5),rep(1,4),rep(0,5),rep(0,2),rep(1,3))) I have two variables x1 and x2. What I want is a dummy variable, named as ‘dummy’, based on both x1 and x2 indicators. Specifically, the dummy should equal 1 by capturing all x1=yes values conditional that at least one of… Read More Create a dummy variable based on two variables x1 and x2 (dummy=x1 only if at least one adjacent x2=yes)

Advertisements I have data containing a list of topics (topics 1-5; and 0 meaning no topic is assigned) and their value. I want to create a new column for each topic and fill the column with the value. Here’s what the table looks like… reviewId topic value 01 2 -4 02 2 9 03 0… Read More Create dummy column and input value from other column

Advertisements I have a question regarding how to craft a variable depending on two other variables. I need to create a dummy variable that will take the value of 1 if Parameter1 is either A or B (but not C) and Parameter2 has a positive value. The variable needs both assumptions to upheld, otherwise will… Read More Creating a variable depending on values of two different parameters

Advertisements How to create a dummy variable if missing values are included? I have the following data and I want to create a Dummy variable based on several conditions. My problem is that it automatically converts my missing values to 0, but I want to keep them as missing values. import pandas as pd mydata… Read More How to create a Dummy Variable in Python if Missing Values are included?

Advertisements Let’s say I have some data as follows: ID FRUIT 001 apple 002 grape 001 banana 002 apple 003 apple 001 apple I would like to make columns out of this, like dummy variables. Except the dummies are counts of the variable in the FRUIT column. So, if ID 001 has apple appear 2… Read More Creating dummy variables as counts using tidyverse/dplyr

Advertisements I have a DataFrame column with 3 values – Bart, Peg, Human. I need to one-hot encode them such that Bart and Peg stay as columns and human is represented as 0 0. Xi | Architecture 0 | Bart 1 | Bart 2 | Peg 3 | Human 4 | Human 5 | Peg… Read More How to specify which column to remove in get_dummies in pandas

Advertisements I’m working with a cross-country panel dataset, one of my variables (cc_dummy) takes the value of 1 & 0 (there are also missing values indicated by NAs). I want to create a new column such that if cc_dummy takes the value 1 for three consecutive years for each country, I want only the first… Read More Creating a conditional dummy variable column in R

Advertisements I am trying to replace NAs in my variable- called violence- with zeros and create a new dummy variable using ifelse. The violence variable has several categories and NAs. The category ignore should be coded 1 but other categories including NAs should be coded 0. I use the following code: df$new_variable<-ifelse(is.na(df$violence)=="ignore",1,0) However, the code… Read More Replace NAs with zeros using ifelse

Advertisements Stata r, u, s are dummies. I’m wondering if the following line is also generating dummy n, if r or u or s ==1, but just omit ==1 after r, u, s? generate byte n = r | u | s R Does it make a difference when we generate byte and variable in… Read More Generate dummies in Stata vs. in R