Tag: plyr

Changing specific column values based on conditions in R

Advertisements I have following dataframe named ‘Saty’ in R One_Day Arrived_Date Departure_Date Yes 2022-01-10 NA No 2021-05-12 2021-06-01 Yes 2021-12-01 2021-12-01 Yes 2022-03-01 NA I want to modify the dataframe, if the One_Day column value is ‘Yes’, my ‘Arrived_Date’ and ‘Departure_Date’ should be same, like below dataframe. One_Day Arrived_Date Departure_Date Yes 2022-01-10 2022-01-10 No 2021-05-12… Read More Changing specific column values based on conditions in R

MRLeave a comment

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

Advertisements 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",… Read More R: Calculate percentage of observations in a column that are below a certain value for panel data

MRLeave a comment

How to use dplyr to return the grouped sum of all numeric columns when there are NA values?

Advertisements I’m was attempting to sum all numeric columns using dplyr’s group_by and summarise functions as below. I didn’t understand the error returned from the summarise function and cannot seem to find a similar example on stack overflow … however after two members pointed out my error in making the example data I found that… Read More How to use dplyr to return the grouped sum of all numeric columns when there are NA values?

MRLeave a comment

Web-Scraping using R (I want to extract some table like data from a website)

Advertisements I’m having some problems scraping data from a website. I do have not a lot of experience with web-scraping. My intended plan is to scrape some data using R from the following website: https://www.myfxbook.com/forex-broker-swaps More precisely, I want to extract the Forex Brokers Swap Comparison for all the available pairs. My idea so far:… Read More Web-Scraping using R (I want to extract some table like data from a website)

MRLeave a comment

Join columns, duplicating existing row for each variable in new column

Advertisements Ok so say we have two different columns of data. One is just a running date column: day 2017-11-08 2017-11-09 2017-11-10 2017-11-13 2017-11-14 2017-11-15 The other is just an ID column ID asdflauih3298b43f9n akjwn3ibfun9834n93n nv43879n4vliuhs87ba I would like to join these columns in a way so that each ID occurs for every day. Like… Read More Join columns, duplicating existing row for each variable in new column

MRLeave a comment

Match 2 data frames based on common rows, and preserving the order of rownames

Advertisements I need to amend the dataframe "DF1" by matching its 1st (and only) column with 2nd column of "DF2" and printing the matched column by preserving the order of rownames in DF1. I also need to replace the non-matching rows with 0. These are two examples of the data frames I have: "DF1" Ccd… Read More Match 2 data frames based on common rows, and preserving the order of rownames

MRLeave a comment