search

USAID-OHA-SI / glamr

SI Utilities
https://usaid-oha-si.github.io/glamr/
Other
2 stars 3 forks source link

Create a fy and quarter rename function to get period #57

Closed achafetz closed 2 years ago

achafetz commented 2 years ago

@tessam30: without changing the base code, is there an option in reshape_msd() to keep missing qtrs? pry easier to just pivot_longer

@achafetz no. my cheat when I do want to keep blank rows is to convert all the NAs to -99 and then rehape_msd() and then convert those values back to NA I think pivot longer is more work because of the period renaming

goal = creat an additional function for cleaning up pivot_longer() to unite fiscal_year and quarter and clean to get the right period.

convert_fy_qtr_to_period(df, qtr_ind = "qtr")