Very instructive. I had a similar situation with a table (actually imported not scraped) that contained the same variable twice in the colums (e.g. Sample for one and then a, b, c etc. and sample with a, b, c). The way I handled this was to separate the data into two tables - clean up the tables and then rejoin them.
I notice that one can choose wide format for the columns on the website which eliminates the intermediate subheadings. However, I am not sure how to locate the html tags or css for that.
Amazing Samer. I really got a good case to implement those ideas and just did however, I have couple of column names that have this at the beginning "^cumulative_cumulative_" how would I use across or something similar to replace all those column names with a single "cumulative_"
Please help I am getting the error "Error in UseMethod("html_table") : no applicable method for 'html_table' applied to an object of class "xml_missing"
Very instructive. I had a similar situation with a table (actually imported not scraped) that contained the same variable twice in the colums (e.g. Sample for one and then a, b, c etc. and sample with a, b, c). The way I handled this was to separate the data into two tables - clean up the tables and then rejoin them.
man! thank you for this. I love it. very informative
Many thanks for your support, Ahmad!!
excellent tutorial keep doing more in R
Many, many thanks, Samer. That was really informative. More importantly, it was clearly explained
Thank you for your kind feedback. I'm glad you found it helpful!
How many times do we need to say thanks for this content, Huge like.
I notice that one can choose wide format for the columns on the website which eliminates the intermediate subheadings. However, I am not sure how to locate the html tags or css for that.
Amazing Samer. I really got a good case to implement those ideas and just did
however, I have couple of column names that have this at the beginning
"^cumulative_cumulative_"
how would I use across or something similar to replace all those column names with a single "cumulative_"
you could use str_replace_all to replace all the cumulative_cumulative_ instances with cumulative_
Please help I am getting the error "Error in UseMethod("html_table") :
no applicable method for 'html_table' applied to an object of class "xml_missing"
🤩🤩🤩
The janitor package might be able to deal with the column names.
I had discovered that package much later lol