Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 . The deaths.csv portion of the data from NYC about causes of death for the year 2 0 1 0 . Dataset format: CSV

1. The deaths.csv portion of the data from NYC about causes of death for the year 2010.
Dataset format: CSV
Field names (in order): Year, Ethnicity, Sex, Cause of Death, Death Count.
Answer the following questions from this data using UNIX commands. (CUT and AWK --in two ways )
1.1: How many male record groups and how many female record groups does
the data have?
1.2: How many white female groups are there? Copy entire records of females to
a new text file where the records are organized by death count in descending
order.
1.3: List all causes of death by their counts in descending order; do not worry
about summing any rows together, just sort the count of causes of death
column. What are the three most common causes of death for black males, and
five least common causes of death for hispanic females?
2010 Asian Female Malignant Neoplasms (cancer)415
2010 Asian Female Diseases of Heart 394
2010 Asian Female Cerebrovascular Disease (stroke)89
2010 Asian Female Influenza (Flu) and Pneumonia 74
2010 Asian Female Diabetes Mellitus 51
2010 Asian Female Essential Hypertension and Renal Diseases 33
2010 Asian Female Chronic Lower Respiratory Diseases 28
2010 Asian Female Accidents Except Drug Poisoning 25
2010 Asian Female Certain Conditions Originating in the Perinatal Period 18
2010 Asian Female Intentional Self-Harm (Suicide)17
2010 Asian Female Nephritis and Nephrotic Syndromes 15
2010 Asian Female Alzheimer's Disease 14
2010 Asian Female Non-Hodgkins's Lymphoma 13
2010 Asian Female Leukemia 11
2010 Asian Female Chronic Liver Disease and Cirrhosis 10
2010 Asian Female Insitu or Benign / Uncertain Neoplasms 9
2010 Asian Female Assault (Homicide)7
2010 Asian Female Congenital Malformations and Chromosomal Abnormalities 7
2010 Asian Female Septicemia 7
2010 Asian Female Viral Hepatitis 5
2010 Asian Female Aortic Aneurysm and Dissection 4
2010 Asian Female Atherosclerosis 4
2010 Asian Female Maternal Causes 4
2010 Asian Female Parkinson's Disease 4
2010 Asian Female Peptic Ulcer 4
2010 Asian Female Pregnancy and Childbirth 4
2010 Asian Female Human Immunodeficiency Virus (HIV) Disease 3
2010 Asian Female All Censored Causes 2
2010 Asian Female Cholelithiasis and Disorders of Gallbladder 2
2010 Asian Female Anemias 1
2010 Asian Female Mental and Behavioral Disorders due to use of or Accidental Poisoning by Psychoactive Substances Excluding Alcohol and Tobacco 1
2010 Asian Female Tuberculosis (TB)1
2010 Asian Male Malignant Neoplasms (cancer)526
2010 Asian Male Diseases of Heart 479
2010 Asian Male Influenza (Flu) and Pneumonia 108
2010 Asian Male Cerebrovascular Disease (stroke)83
2010 Asian Male Diabetes Mellitus 64
2010 Asian Male Chronic Lower Respiratory Diseases 61
2010 Asian Male Accidents Except Drug Poisoning 54
2010 Asian Male Intentional Self-Harm (Suicide)46
2010 Asian Male Essential Hypertension and Renal Diseases 30
2010 Asian Male Non-Hodgkins's Lymphoma 19
2010 Asian Male Chronic Liver Disease and Cirrhosis 18
2010 Asian Male Certain Conditions Originating in the Perinatal Period 17
2010 Asian Male Leukemia 17
2010 Asian Male Viral Hepatitis 14
2010 Asian Male Nephritis and Nephrotic Syndromes 11
2010 Asian Male Septicemia 11
2010 Asian Male Alzheimer's Disease 9
2010 Asian Male Assault (Homicide)9
2010 Asian Male Congenital Malformations and Chromosomal Abnormalities 9
2010 Asian Male Mental and Behavioral Disorders due to use of Alcohol 9
2010 Asian Male Insitu or Benign / Uncertain Neoplasms 7
2010 Asian Male Parkinson's Disease 7
2010 Asian Male Atherosclerosis 6
2010 Asian Male Cholelithiasis and Disorders of Gallbladder 6
2010 Asian Male Anemias 5
2010 Asian Male Aortic Aneurysm and Dissection 5
2010 Asian Male Tuberculosis (TB)5
2010 Asian Male Mental and Behavioral Disorders due to use of or Accidental Poisoning by Psychoactive Substances Excluding Alcohol and Tobacco 4
2010 Asian Male Peptic Ulcer 4
2010 Asian Male Human Immunodeficiency Virus (HIV) Disease 3
2010 Asian Male All Censored Causes 1
2010 Asian Male Complications of Medical and Surgical Care 1
2010 Asian Male Legal Intervention 1
2010 Asian Male Meningitis 1
2010 Hispanic Female Diseases of Heart 1316
2010 Hispanic Female Malignant Neoplasms (cancer)1045
2010 Hispanic Female Influenza (Flu) and Pneumonia 228
2010 Hispanic Female Diabetes Mellitus 219
2010 Hispanic Female Cerebrovascular Disease (stroke)168
2010 Hispanic Female Chronic Lower Respiratory Diseases 156
2010 Hispanic Female Essential Hypertension and Renal Diseases 95
2010 Hispanic Female Human Immunodeficiency Virus (HIV) Disease 79
2010 Hispanic Female Alzheimer's Disease 71
2010 Hispanic Female Accidents Except Drug Poisoning 58
2010 Hispanic Female Mental and Behavioral Disorders due to use of or Accidental Poisoning by Psychoactive Substances Excluding Alcohol and Tobacco 50
2010 Hispanic Female Chronic Liver Disease and Cirrhosis 49
2010 Hispanic Female Nephritis

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Put Your Data To Work 52 Tips And Techniques For Effectively Managing Your Database

Authors: Wes Trochlil

1st Edition

0880343079, 978-0880343077

More Books

Students also viewed these Databases questions

Question

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago