Session 4
2024-02-27
The article “Measuring Public Support for European Integration across Time and Countries: The ‘European Mood’ Indicator” by Isabelle Guinaudeau and Tinette Schnatterer addresses the challenge of measuring public support for the European Union (EU), in the context of increasing contestation of European integration. They emphasize the need for a consistent and comparable instrument to measure citizens’ preferences and to analyze the dynamic relationship between public opinion, party politics, and policy making.
In this article, Hermann Schmitt, Sara B. Hobolt, and Wouter van der Brug describe the results of a post-election study, conducted in all 28 EU member states after the elections to the European Parliament were held between 23 and 26 May 2019. The main objective of the 2019 EES Voter study is to study electoral participation and voting behaviour in European Parliament elections.
In particular, question 10 ask how probable is it that people will ever vote for different parties in their country.
Reshaping involves restructuring data to transform it from a wide format to a long format or vice versa.
Splitting involves breaking a dataset into smaller groups based on a specified variable, allowing for separate analysis and manipulation of each group’s data.
Merging involves combining multiple datasets based on shared variables to create a single unified dataset:
exam1_solution.R
(Subject : “DSR Exam 1 Submission”, To : kim.antunez@sciencespo.fr)Exercise 2 from today (questions 1 to 7)
1 preparation exercise (in group & ungraded, for now)
Handbooks, videos, cheatsheets
Databases serve as organized repositories of data structured into tables with defined relationships:
Two main approaches are available for managing data within databases:
The dbplyr
package acts as a connector that extends the capabilities of dplyr
. It relies on ODBC/DBI drivers, which enable R to connect and communicate with a diverse array of database management systems:
There are also specialized drivers available for MonetDB such as:
But also :
bigrquery
R package for Google BigQuery, a cloud-based data warehousing solution.You can refer to Chapter 22 (ʻDatabasesʼ) in the book “R for Data Science” by Grolemund and Wickham or here.