Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save elliottmorris/94ac7a4dc7b96aa13294aa18794c5803 to your computer and use it in GitHub Desktop.
Save elliottmorris/94ac7a4dc7b96aa13294aa18794c5803 to your computer and use it in GitHub Desktop.
trump issue approval march 2025
library(tidyverse)
library(janitor)
dat = read_csv('~/Downloads/Trump issue approval march - Sheet1.csv')
dat = clean_names(dat)
dat %>% group_by(category) %>%
summarise_at(c('approve', 'disapprove', 'net'), mean) %>%
mutate_if(is.numeric,round_half_up,1) %>%
arrange(net) %>% view
Pollster,Item,Category,Approve,Disapprove,Net,Link
YouGov,The economy,The economy,43,51,-8,https://d3nkl3psvxxpe9.cloudfront.net/documents/econTabReport_Uo7FRzc.pdf
YouGov,Health care,Health care,40,48,-8,https://d3nkl3psvxxpe9.cloudfront.net/documents/econTabReport_Uo7FRzc.pdf
YouGov,Crime,Crime,48,41,7,https://d3nkl3psvxxpe9.cloudfront.net/documents/econTabReport_Uo7FRzc.pdf
YouGov,Immigration,Immigration,51,44,7,https://d3nkl3psvxxpe9.cloudfront.net/documents/econTabReport_o8LZals.pdf
YouGov,Government spending,Government spending,46,46,0,https://d3nkl3psvxxpe9.cloudfront.net/documents/econTabReport_o8LZals.pdf
YouGov,Foreign policy,Foreign policy,44,49,-5,https://d3nkl3psvxxpe9.cloudfront.net/documents/econTabReport_ngfganU.pdf
AP-NORC,The economy,The economy,40,58,-18,https://apnorc.org/wp-content/uploads/2025/03/March-2025-topline-Trump-.pdf
AP-NORC,Israel/Palestine,Israel/Palestine,44,54,-10,https://apnorc.org/wp-content/uploads/2025/03/March-2025-topline-Trump-.pdf
AP-NORC,Immigration,Immigration,49,50,-1,https://apnorc.org/wp-content/uploads/2025/03/March-2025-topline-Trump-.pdf
AP-NORC,Trade,Trade and tariffs,38,60,-22,https://apnorc.org/wp-content/uploads/2025/03/March-2025-topline-Trump-.pdf
AP-NORC,Government spending,Government spending,46,51,-5,https://apnorc.org/wp-content/uploads/2025/03/March-2025-topline-Trump-.pdf
AP-NORC,Social Security ,Social Security ,41,56,-15,https://apnorc.org/wp-content/uploads/2025/03/March-2025-topline-Trump-.pdf
AP-NORC,Russia/Ukraine,Russia/Ukraine,41,56,-15,https://apnorc.org/wp-content/uploads/2025/03/March-2025-topline-Trump-.pdf
AP-NORC,Managing the government,Managing the government,43,55,-12,https://apnorc.org/wp-content/uploads/2025/03/March-2025-topline-Trump-.pdf
Echelon Insights,The economy,The economy,47,49,-2,https://echelonin.wpenginepowered.com/wp-content/uploads/March-2025-Voter-Omnibus-Topline-External.pdf
Echelon Insights,Immigration,Immigration,57,39,18,https://echelonin.wpenginepowered.com/wp-content/uploads/March-2025-Voter-Omnibus-Topline-External.pdf
Echelon Insights,Foreign policy,Foreign policy,48,46,2,https://echelonin.wpenginepowered.com/wp-content/uploads/March-2025-Voter-Omnibus-Topline-External.pdf
Echelon Insights,Tariffs,Trade and tariffs,41,51,-10,https://echelonin.wpenginepowered.com/wp-content/uploads/March-2025-Voter-Omnibus-Topline-External.pdf
Echelon Insights,Russia/Ukraine,Russia/Ukraine,44,47,-3,https://echelonin.wpenginepowered.com/wp-content/uploads/March-2025-Voter-Omnibus-Topline-External.pdf
CNN,The economy,The economy,44,56,-12,https://s3.documentcloud.org/documents/25558091/cnn-poll-trumps-performance-and-economy.pdf
CNN,Health care,Health care,43,56,-13,https://s3.documentcloud.org/documents/25558091/cnn-poll-trumps-performance-and-economy.pdf
CNN,Immigration,Immigration,51,48,3,https://s3.documentcloud.org/documents/25558091/cnn-poll-trumps-performance-and-economy.pdf
CNN,Foreign policy,Foreign policy,42,58,-16,https://s3.documentcloud.org/documents/25558091/cnn-poll-trumps-performance-and-economy.pdf
CNN,Tariffs,Trade and tariffs,39,61,-22,https://s3.documentcloud.org/documents/25558091/cnn-poll-trumps-performance-and-economy.pdf
CNN,Managing the government,Managing the government,48,51,-3,https://s3.documentcloud.org/documents/25558091/cnn-poll-trumps-performance-and-economy.pdf
CNN,The federal budget,Government spending,48,52,-4,https://s3.documentcloud.org/documents/25558091/cnn-poll-trumps-performance-and-economy.pdf
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment