PLEASE read the question carefully before you start to work $,$ just in case negtive feedback. THX$!$

$**********************$

deaths.csv contains a 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.

$1\mathrm{.}1$: How many male record groups and how many female record groups does the data have?

$1\mathrm{.}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\mathrm{.}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?

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

Q$1$ result shows like this:

$161$ Female

$163$ Male

$*******************************************************$deaths$.$csv

$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