Advertisement
chronus

Untitled

Jan 25th, 2023
1,846
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
R 0.54 KB | None | 0 0
  1. ban <- read_csv('ban_data_sample.csv')
  2. comb <- read_csv('comb_data.csv')
  3.  
  4. ban <- ban %>%
  5.   mutate(ind = paste(SecurityInBan, Date, sep = " | "),
  6.          inBan = T)
  7.  
  8. comb2 <- comb %>%
  9.   select(-1) %>%
  10.   filter(ticker %in% ban$SecurityInBan) %>%
  11.   group_by(ticker) %>%
  12.   mutate(ind = paste(ticker, date, sep = " | "))
  13.  
  14. merged <- comb2 %>%
  15. full_join(ban) %>%
  16.   select(date, open, high, low, close, volume, ticker, inBan)%>%
  17.   mutate(inBan = case_when(is.na(inBan) ~ F,
  18.                            TRUE ~ inBan)) %>%
  19.   View()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement