Gathering Data Status Report
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
223
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by DrTree1894
Gathering Data Status Report
Name:
Amelia Madsen
Date:
02/09/2023
Status Report for Gathering Data
Status
Progress
Variables of Interest
GENHLTH: linking general health to health care coverage and smoking/asthma
could be helpful for the campaign.
HLTHPLN1: this value shows if they have health coverage or not.
MEDCOST: tells if they have been unable to see a doctor due to cost which
could be related to lack of health coverage.
ASTHMA3: denotes whether they’ve been told they have asthma.
SMOKE100: tells if the patient has smoked more than 100 cigarettes which
would categorize them as a smoker.
SMOKDAY2: tells how frequently they smoke if they currently still smoke
Data Set Preparation
GENHLTH
HLTHPLN1
MEDCOST
ASTMA3
SMOKE100
SMOKDAY2
Gathering Data*
The new table in SQL is shown on following page.
Process for Gathering
Data
After identifying the data values that were needed, I opened the CSV file and
deleted all columns that were not those that I needed.
I then added a column with ascending numbers 1-3999 to create a primary
key that would allow for easier migration to SQL. Without a primary key SQL
gives an error when importing and none of the current values can be primary
keys as they would all have duplicate values.
I then deleted the first row which denoted the column headers.
I then created a matching table in SQL where the first 4 columns allow integer
values. SMOKE100 and SMOKDAY2 were set to variable characters because
not every entry has a value for these two categories meaning the entry in the
CSV will not be an integer like the others.
I then imported the CSV to SQL and saved it, the result is shown on following
page.
*Gathering Data
The resulting table from importing the revised CSV file into SQL.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help