IBM Data Science Chicago Assignment

A project with data from Chicago's education, census and crime

@kaggle.antonioskokiantonis_ibm_data_science_chicago_assignment

Table List

3 tables(249.69 KB)

Chicagocensusdata

Chicagocrimedata

Chicagopublicschools

Chicagocensusdata

@kaggle.antonioskokiantonis_ibm_data_science_chicago_assignment.chicagocensusdata

11.88 KB
78 rows
9 columns

community_area_number COMMUNITY AREA NUMBER	community_area_name COMMUNITY AREA NAME	percent_of_housing_crowded PERCENT OF HOUSING CROWDED	percent_households_below_poverty PERCENT HOUSEHOLDS BELOW POVERTY	percent_aged_16_unemployed PERCENT AGED 16, UNEMPLOYED	percent_aged_25_without_high_school_diploma PERCENT AGED 25, WITHOUT HIGH SCHOOL DIPLOMA	percent_aged_under_18_or_over_64 PERCENT AGED UNDER 18 OR OVER 64	per_capita_income PER CAPITA INCOME	hardship_index HARDSHIP INDEX
1	Rogers Park	7.7	23.6	8.7	18.2	27.5	23939	39
2	West Ridge	7.8	17.2	8.8	20.8	38.5	23040	46
3	Uptown	3.8	24	8.9	11.8	22.2	35787	20
4	Lincoln Square	3.4	10.9	8.2	13.4	25.5	37524	17
5	North Center	0.3	7.5	5.2	4.5	26.2	57123	6
6	Lake View	1.1	11.4	4.7	2.6	17	60058	5
7	Lincoln Park	0.8	12.3	5.1	3.6	21.5	71551	2
8	Near North Side	1.9	12.9	7	2.5	22.6	88669	1
9	Edison Park	1.1	3.3	6.5	7.4	35.3	40959	8
10	Norwood Park	2	5.4	9	11.5	39.5	32875	21


CREATE TABLE chicagocensusdata (
  "community_area_number" DOUBLE,
  "community_area_name" VARCHAR,
  "percent_of_housing_crowded" DOUBLE,
  "percent_households_below_poverty" DOUBLE,
  "percent_aged_16_unemployed" DOUBLE,
  "percent_aged_25_without_high_school_diploma" DOUBLE,
  "percent_aged_under_18_or_over_64" DOUBLE,
  "per_capita_income" BIGINT,
  "hardship_index" DOUBLE
);