How to reset a sequence in a R dataframe's column, based on the levels of a different column Problem Description: I have data that logs subject and session information in columns like so: > Subject <- c(rep("A", 6), rep("B", 7)) > Session <- c(rep(1, 3), rep(2, 3), rep(8, 4), rep(9, 3)) > df <- data.frame(Subject, … Read more
Why am I getting KeyErrors when accessing multiple rows in a dataframe? Problem Description: I am trying to write the following condition to map MARKET_STATES.OPENING_AUCTION, however I am getting KeyError: (False, False, False) when I run the following: market_info_df.loc[market_info_df[‘issue_status’ == ’10’, ‘market_phase’ == ‘0’, ‘trading_state’ == ‘ ‘].iloc[0]] = MARKET_STATES.OPENING_AUCTION Two questions: What is it … Read more
looping over dataframes and looping over variables in a dataframe Problem Description: Stata user here, having trouble with loops in R. I won’t trouble you with the "how I would do it in stata" caveat; my issue sis that using loops (or apply) I cannot figure out how to properly loop through data frames or … Read more
filter a DataFrame using complete word only Problem Description: I have a large DataFrame (named: complete) of data (only two columns). I want to filter it using complete words only, instead of substrings. Ex: complete dataframe: comment sentiment fast running 0.9 heavily raining 0.5 in the house 0.1 coming in 0.0 rubbing it -0.5 if … Read more
Change the name of columns based on a period in df Problem Description: I have a df and I want to change the name of column based on a period. For example, in the following df, I have 15 columns with name v0-14. I want to rename it to v0-v2, and after three columns, again … Read more
Remove duplicates based on combination of two columns in Pandas Problem Description: I need to delete duplicated rows based on combination of two columns (person1 and person2 columns) which have strings. For example person1: ryan and person2: delta or person 1: delta and person2: ryan is same and provides the same value in messages column. … Read more
Pandas: Replace and remove character in columns Problem Description: I have a dataframe in pandas, in this format: I need to perform formatting on my dataframe that is larger than this, generally speaking only on the ‘CTe’ column CTe = ["1221-2","12321-45","123-3"] UF = [‘A’,’B’,’C’] df = pd.DataFrame( data = zip(CTe,UF), columns=["CTe","UF"]) And I would like … Read more
Check if the corresponding elements in two different list of dataframes are equal Problem Description: I have a two separate list of dataframes. The first list of dataframe is lst1 $`1` [1] 8.523769e-05 6.615035e-05 1.177740e-04 1.173578e-04 8.798214e-05 6.328218e-05 4.768889e-05 3.658710e-05 [9] 1.294623e-05 1.179838e-06 1.010590e-06 5.204994e-07 2.128048e-06 6.876634e-06 6.011750e-06 5.160903e-05 [17] 5.318722e-05 1.029438e-04 1.173397e-04 $`2` [1] … Read more
For loop in R not working to update data set Problem Description: I am trying to apply this for loop across the given minimal dataset. Each row of the dataset is associated with a patient, with each patient having two rows of information. The aim is that the cohort of each patient is determined. Each … Read more
How to transpose certain columns in a pandas dataframe Problem Description: Currently have a dataframe like this: RepName Hours Reason John 4 Research John 15 Training Matt 6 Project Labor Matt 10 Training I want to transpose each reason as a column with the Hours values as values like so: RepName Research Training Project Labor … Read more