Viktat urval

Analysera enkätdata med Python

EbunOluwa Andrew

Data Scientist

Vad är viktat urval?

Ojämlika sannolikheter
Gör det möjligt att korrigera problem under datainsamlingen

Våg med vågskålar på ett bord

Vanliga variabler vid viktat urval

Demografiska variabler som kön, ålder, plats och utbildning
Tar hänsyn till skillnader mellan de som deltar och inte deltar i studier

Familj, personer i olika åldrar, konturstil

Cellbaserad viktning

¹ https://www.geopoll.com/blog/weighting-survey-data-raking-cell-weighting/

Cellbaserad viktning

¹ https://www.geopoll.com/blog/weighting-survey-data-raking-cell-weighting/

Cellbaserad viktning

¹ https://www.geopoll.com/blog/weighting-survey-data-raking-cell-weighting/

Cellbaserad viktning

¹ https://www.geopoll.com/blog/weighting-survey-data-raking-cell-weighting/

Analysera ungas konsumtionsmönster med Python

yp_survey

| Gender | Age | Entertainment |
|--------|-----|---------------|
| female |  19 | Agree         |
| female |  20 | Agree         |
| male   |  19 | Agree         |
| female |  19 | Disagree      |
| female |  24 | Disagree      |
| male   |  18 | Agree         |
| male   |  18 | Agree         |
| male   |  20 | Disagree      |

Analysera ungas konsumtionsmönster med Python

import pandas as pd
yp_crosstab = pd.crosstab(
  yp_survey['Gender'],
  yp_survey['Entertainment'])
yp_crosstab

yp_crosstab.plot.barh()

|        | Agree | Disagree |
|--------|-------|----------|
| female |    81 |       84 |
| male   |    84 |       46 |

Analysera ungas konsumtionsmönster med Python

survey = yp_survey.groupby(['Gender', 'Entertainment'])['Age'].count().reset_index()

survey.columns = ['Gender', 'Entertainment', 'Respondents']
survey

| Gender | Entertainment | Respondents |
|--------|---------------|-------------|
| female | Agree         |          81 |
| female | Disagree      |          84 |
| male   | Agree         |          84 |
| male   | Disagree      |          46 |

Analysera ungas konsumtionsmönster med Python

survey['% total respondents'] = survey.Respondents * 100./survey.Respondents.sum()

survey['% of population'] = [35, 25, 20, 20]

survey['Weight'] = survey['% of population']/survey['% total respondents']

survey['Weighted Respondents'] = survey.Weight * survey.Respondents

Analysera ungas konsumtionsmönster med Python

survey[['Gender','Entertainment',
        'Respondents','Weighted Respondents']].set_index(
  ['Gender','Entertainment']).plot.barh()

Nu kör vi en övning!

Analysera enkätdata med Python