R: Calculate percentage of observations in a column that are below a certain value for panel data

I have panel data and I would like to get the percentage of observations in a column (Size) that are below 1 million. My data is the following: structure(list(Product = c("A", "A", "A", "A", "A", "A", "B", "B", "B", "B", "B", "B", "C", "C", "C", "C", "C", "C"), Date = c("02.05.2018", "04.05.2018", "05.05.2018", "06.05.2018", "07.05.2018",… Read More R: Calculate percentage of observations in a column that are below a certain value for panel data

May 26, 2022 MRLeave a comment

Check for duplicate rows for a subset of columns in a Pandas DataFrameGroupBy object

Suppose I have a groupby object (grouped on Col1) like below: Col1 Col2 Col3 Col4 Col5 —————————————- AAA 001 456 846 239 row1 002 374 238 904 row2 003 456 846 239 row3 BBB 001 923 222 398 row1 002 923 222 398 row2 003 755 656 949 row3 CCC 001 324 454 565 row1… Read More Check for duplicate rows for a subset of columns in a Pandas DataFrameGroupBy object

May 26, 2022 MRLeave a comment

Pandas create a color for each two value pair

I have a data frame with XY values which I would like to plot in a scatter plot. I would like to create groups which have a same XY values and apply the same color in the plot: df = pd.DataFrame({‘X’: [1.1, 1.1, 5.5, 5.5, 5.5,10.1], ‘Y’: [3.7, 3.7, 5.6, 5.6, 5.6, 3.2], ‘ID’: [‘ID1’,… Read More Pandas create a color for each two value pair

May 26, 2022 MRLeave a comment

How can I use named group in C# regex switch/case?

I want to write a code that checks if it matches to a regular expression then prints matched string. I found other question Can I use regex expression in c# with switch case?, but IsMatch method only returns boolean so I couldn’t retrieve named group string. var filepath = @"path/to/file.txt"; foreach (string line File.ReadLines(filepath)) {… Read More How can I use named group in C# regex switch/case?

May 26, 2022 MRLeave a comment

Pivot_wider: Combine Duplicate Observations AND Create New Variable Columns for Those Values

I’m new to R and have scoured the site to find a solution – I’ve found lots of similar, but slightly different questions. I’m stumped. I have a dataset in this structure: SURVEY_ID CHILD_NAME CHILD_AGE Survey1 Billy 4 Survey2 Claude 12 Survey2 Maude 6 Survey2 Constance 3 Survey3 George 22 Survey4 Marjoram 14 Survey4 LeBron… Read More Pivot_wider: Combine Duplicate Observations AND Create New Variable Columns for Those Values

May 26, 2022 MRLeave a comment

rank for nan values based on group

I have dataframe with column d1 and now i am trying calculate ‘out’ column after ranking that column when there in ‘nan’ value with in a column. data_input = {‘Name’:[‘Renault’, ‘Renault’, ‘Renault’, ‘Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’], ‘type’:[‘Duster’, ‘Duster’, ‘Duster’,’Duster’,’Duster’,’Duster’,’Duster’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’], ‘d1’:[‘nan’,’10’,’10’,’10’,’nan’,’nan’,’20’,’20’,’nan’,’nan’,’30’,’30’,’30’,’nan’]} df_input = pd.DataFrame(data_input) data_out = {‘Name’:[‘Renault’, ‘Renault’, ‘Renault’, ‘Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’], ‘type’:[‘Duster’, ‘Duster’, ‘Duster’,’Duster’,’Duster’,’Duster’,’Duster’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’], ‘d1’:[‘nan’,’10’,’10’,’10’,’nan’,’nan’,’20’,’20’,’nan’,’nan’,’30’,’30’,’30’,’nan’], ‘out’:[1,np.NaN,np.NaN,np.NaN,2,2,np.NaN,np.NaN,1,1,np.NaN,np.NaN,np.NaN,2]} df_out = pd.DataFrame(data_out) If… Read More rank for nan values based on group

May 25, 2022 MRLeave a comment

cut command top remove seconds from time. shell scripting

Lets say we got date and time to a log in the format of 2022-05-18-11:57:140100 I need to remove seconds from this time. It means the final output should be like 2022-05-18-11:57 I tried the following echo "2022-05-18-11:57:140100" | rev | cut -d/ -f6- | rev`:" this was not successful and I have no idea… Read More cut command top remove seconds from time. shell scripting

May 24, 2022 MRLeave a comment

NGINX – Handle both ID or Username

I have 2 urls like this: 1 – example.com/user/JohnFifty/ 2 – example.com/user/45771/ Both work, but only one or the other. I want to allow both, which is enabled in the PHP code. I have tried if ($arg_id ~ ([\d]+)[^\d]) { rewrite ^/user/([^/]*)/$ /user.php?id=$1 last; } rewrite ^/user/([^/]*)/$ /user.php?username=$1 last; In order to detect the case,… Read More NGINX – Handle both ID or Username

May 24, 2022 MRLeave a comment

How to group by one column or another in pandas

I have a table like: col1 col2 0 1 a 1 2 b 2 2 c 3 3 c 4 4 d I’d like rows to be grouped together if they have a matching value in col1 or col2. That is, I’d like something like this: > ( df .groupby(set(‘col1’, ‘col2’)) # Made-up syntax .ngroup())… Read More How to group by one column or another in pandas

May 23, 2022 MRLeave a comment

array of objects group them by a specific key

I have the following array const arr = [{ agrupacion: "Total país", valor: "81.8", year: 2015 }, { agrupacion: "Total país", valor: "86.4", year: 2016 }, { agrupacion: "Total país", valor: "67.3", year: 2017 }, { agrupacion: "Total país", valor: "70.8", year: 2018 }, { agrupacion: "Total país", valor: "67.6", year: 2019 }, { agrupacion:… Read More array of objects group them by a specific key

May 23, 2022 MRLeave a comment

Dev solutions

Solutions for development problems

Tag: groups

R: Calculate percentage of observations in a column that are below a certain value for panel data

Check for duplicate rows for a subset of columns in a Pandas DataFrameGroupBy object

Pandas create a color for each two value pair

How can I use named group in C# regex switch/case?

Pivot_wider: Combine Duplicate Observations AND Create New Variable Columns for Those Values

rank for nan values based on group

cut command top remove seconds from time. shell scripting

NGINX – Handle both ID or Username

How to group by one column or another in pandas

array of objects group them by a specific key