Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Women of Color in Congress data #425

Open
PythonCoderUnicorn opened this issue Feb 21, 2022 · 2 comments
Open

Women of Color in Congress data #425

PythonCoderUnicorn opened this issue Feb 21, 2022 · 2 comments
Labels
data: needs compilation Sometimes the suggestion requires us to scrape the data (not just clean). Flag for extra work. dataset requested PR

Comments

@PythonCoderUnicorn
Copy link
Contributor

Hi again! : )

I have gathered a dataset from data.world, source and the data was created 4 years ago.

The only description that came with data was:

There have been 52 African-American women who have served in Congress. The first African-American woman elected to Congress, Shirley Chisholm of New York, won election to the House in 1968. site

I did some data cleaning on the dates_of_service column. The data has 67 rows and 5 columns.

women_of_color_congress.csv

library(tidyverse)

WOCC = read_csv('~/Downloads/women_of_color_congress.csv') %>% janitor::clean_names()

glimpse(WOCC)

WOCC = WOCC %>% 
  rename(state =x3)

# "1965\xd01977; 1990\xd02002" 
WOCC$dates_of_service = str_replace_all(WOCC$dates_of_service, pattern = "\\xd0",replacement = '-')

#  "1965�1977;
WOCC$dates_of_service = str_replace_all(WOCC$dates_of_service, pattern = "�",replacement = '-')

Data Dictionary

variable class description
name chr name of Congress Woman
party_state chr political party of US State
state chr abbreviated State name
dates_of_service chr year date ranges of service
ethnicity chr Congress Woman ethnicity
@jonthegeek jonthegeek added the data: needs compilation Sometimes the suggestion requires us to scrape the data (not just clean). Flag for extra work. label Jan 12, 2024
@jonthegeek
Copy link
Collaborator

I'd love to use this (or something close), but I feel like we should try to make it as up-to-date as possible.

@lgibson7
Copy link
Member

Hi @PythonCoderUnicorn. Thanks for submitting this issue. Would you be willing to submit the data set through a PR? You can find the instructions on how to do so here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
data: needs compilation Sometimes the suggestion requires us to scrape the data (not just clean). Flag for extra work. dataset requested PR
Projects
None yet
Development

No branches or pull requests

3 participants