Calcolare la percentuale di donne in una contea

Il dataset include colonne con il numero totale (non la percentuale) di uomini e donne in ogni contea. Puoi usare questo, insieme alla variabile population, per calcolare la frazione di uomini (o donne) all'interno di ciascuna contea.

In questo esercizio, selezionerai tu le colonne rilevanti.

Questo esercizio fa parte del corso

Manipolazione dei dati con dplyr

Visualizza il corso

Istruzioni dell'esercizio

Seleziona le colonne state, county, population, men e women.
Aggiungi una nuova variabile chiamata proportion_women con la frazione della popolazione della contea composta da donne.

Esercizio pratico interattivo

Prova a risolvere questo esercizio completando il codice di esempio.

counties_selected <- counties %>%
  # Select the columns state, county, population, men, and women
  ___

counties_selected %>%
  # Calculate proportion_women as the fraction of the population made up of women
  ___

Modifica ed esegui il codice

Questo esercizio fa parte del corso

Manipolazione dei dati con dplyr

InicianteNível de habilidade

4.8+

618 reviews

Inizia il corso gratis

Learn verbs you can use to transform your data, including select, filter, arrange, and mutate. You'll use these functions to modify the counties dataset to view particular observations and answer questions about the data.

Exercise 1: Esplorare i dati con dplyr Exercise 2: Capire i tuoi dati Exercise 3: Selezionare colonne Exercise 4: I verbi filter e arrange Exercise 5: Ordinare le osservazioni Exercise 6: Filtrare per condizioni Exercise 7: Filtrare e ordinare Exercise 8: Il verbo mutate()Exercise 9: Calcolare il numero di dipendenti pubblici Exercise 10: Calcolare la percentuale di donne in una contea

Esercizio in corso

Exercise 11: Mutate, filter e arrange

Now that you know how to transform your data, you'll want to know more about how to aggregate your data to make it more interpretable. You'll learn a number of functions you can use to take many observations in your data and summarize them, including count, group_by, summarize, ungroup, and slice_min/slice_max.

Exercise 1: The count verb Exercise 2: Counting by region Exercise 3: Counting citizens by state Exercise 4: Mutating and counting Exercise 5: The group_by, summarize, and ungroup verbs Exercise 6: Summarizing Exercise 7: Summarizing by state Exercise 8: Summarizing by state and region Exercise 9: The slice_min and slice_max verbs Exercise 10: Selecting a county from each region Exercise 11: Finding the lowest-income state in each region Exercise 12: Using summarize, slice_max, and count together

Learn advanced methods to select and transform columns. Also, learn about select helpers, which are functions that specify criteria for columns you want to choose, as well as the rename verb.

Exercise 1: Selecting Exercise 2: Selecting columns Exercise 3: Select helpers Exercise 4: The rename verb Exercise 5: Renaming a column after count Exercise 6: Renaming a column as part of a select Exercise 7: The relocate verb Exercise 8: Using relocate Exercise 9: Choosing among the four verbs

Work with a new dataset that represents the names of babies born in the United States each year. Learn how to use grouped mutates and window functions to ask and answer more complex questions about your data. And use a combination of dplyr and ggplot2 to make interesting graphs to further explore your data.

Exercise 1: The babynames data Exercise 2: Filtering and arranging for one year Exercise 3: Finding the most popular names each year Exercise 4: Visualizing names with ggplot2 Exercise 5: Grouped mutates Exercise 6: Finding the year each name is most common Exercise 7: Adding the total and maximum for each name Exercise 8: Visualizing the normalized change in popularity Exercise 9: Window functions Exercise 10: Using ratios to describe the frequency of a name Exercise 11: Biggest jumps in a name Exercise 12: Congratulations!