I have a dataframe that indicates for each ID, the neighboring IDs. My second dataframe contains a count value for each unique ID.

The simple data is:

The simple data is:

I have pooled cross section data (df)of different states at different points in time. I’m trying to see how weather events during crops’ growing period affected how the crops are currently priced. To do so, I would like to lag my precipitation variable by 1 month, 2 months, and 3 months and add these new variables to df . My current df looks like this:

The data is:

I am generating a frequency table with code table(data$col1, data$col2). col1 has Yes/No variables while col2 has count of U/R variables The resulting table has structure

I read the excel file shown in the image below into R using the read_excel() from the readxl package. Is there a way for me to turn the data into a table where it counts the number of Locations by Company as shown in the image below? Thanks.

I have dataset of multiple columns with group variables. I want group values into single column

This question already has answers here: How to make R stop accepting partial matches for column names? (1 answer) Why does R use partial matching? (1 answer) list members can be accessed with partial name? Is this a feature? (2 answers) Closed 19 mins ago. This is probably a “smart” solution that, after more than […]