vermont | VERsatile MONitoring Toolkit ) is an open-source software | Learning library

I've written a function to pull data into a highcharter cloropleth map. I'm having a very difficult time trying to figure out how to format the values going into the map based on whether they are counts (needing format with commas and no decimal places) or percents(needing to be multiplied by 100 and a % sign added as prefix)

The function takes in a dataframe x and selects the variable corresponding to the label assigned to the desired variable which is provided as y. In this reprex you can change out "Count" for "Percent" to change the map. In my actual dashboard, the map changes dynamically based on which variable label is selected through a dropdown input selector using flexdashboard.

I think that the solution should be to create an if statement within the hc_tooltip() to apply a comma format with no decimals if the value is > 1 or multiply the value by 100 and add a % prefix if value < 1.

I've tried reading highcharter documentation to attempt to figure this out but I really have zero formal programming training and don't know any javascript so the highcharter documentation is very hard for me to understand. It seems like one way it could be done is to use a JS function within hc_tooltip(), something like hc_tooltip(formatter = JS("function() {}). I can't figure out how to reference the values of {point.value} within a function like that. I've found a few stackoverflow posts that seem to be similar to my problem but I don't understand how to modify my code to make them work. One post I've been trying to understand is this one: Tooltip content within a highchart in Rshiny

I've tried using scales::percent() and scales::comma() on the appropriate values in the dataframe before they are passed to the map (like right after creating df) but it seems like hc_add_series_map() doesn't like it when the variables are passed in that way.

Please help me understand how to solve this or provide a solution that I can use to understand. In my short time learning to code in R I think this might be the thing I've struggled with the longest and I'm feeling pretty dispirited right now that I can't figure this out.

I have an issue where I need to do some tricky conditional imputation for missing values while flagging those imputed values, but I can't quite figure out how to approach it.

My data is in Tidy (long) format. What I want to do is produce a complete dataset where each "state" has a complete set of rows with "Births" values for "Male", "Female", and "Total". If "Total" is missing for a state, it is imputed from "Male" + "Female" for that "state". If we have "Total", but not either "Male" or "Female", the missing "Births" value is calculated from "Total" - "Male" (or "Female", depending on what is the missing one).

HOWEVER, the missing values can only be imputed if the "source" is the same for all of the present rows for that state. We cannot impute based on combining data from different sources. Finally, all imputed rows should have their parent state and source and should have a "1" flag for the binary "aggregated" column.

The reprex is below and the desired outcome example is below that with a quick explanation. I'd like to do this with Tidyverse if possible, but I am open to better solutions. Thank you in advance!!

I am a new python user here. I have been writing a code that uses selenium and beautiful soup to go to a website and get the html table and turn it into a data frame.

I am using selenium to loop though a number of different pages and beautiful soup to collect the table from there.

The issue that I am running into is I can't get all those tables to append to each other. If i print off the dataframe it only prints the last table that was scraped. How do I tell beautifulsoup to append one dataframe to the bottom of the other?

Any help would be greatly appreciated, it's been a couple days at this one little part.

I have created a select2 field that changes an input field's value to the selected options.

I get it to shop correctly when I select it but the selected are not separated by a comma need help please

I'm trying to check if the CSV file contains all the states from the U.S. As you can see in my code I've imported the CSV file as a list in Python. I'm trying to solve this problem, without using pandas or another module.

I've created a list of the states, but I'm wondering what is the most efficient solution to check what how many states the CSV dataset contains?

I have a dataframe, df, of salary data:

This is the data as a list:

I have a Visualforce page form to create Leads in Salesforce

In the form I want to add the State Picklist.

On the Lead object Address is a composite field. As per documentation, the State field is as seen here -

I want the State on the visualforce page to look like this. i.e when I click on Select a State , I should see the list of State that i can choose from.

This is the CSS code I tried