medical_data = \
"""Marina Allison ,27 , 31.1 ,
#7010.0 ;Markus Valdez , 30,
22.4, #4050.0 ;Connie Ballard ,43
, 25.3 , #12060.0 ;Darnell Weber
, 35 , 20.6 , #7500.0;
Sylvie Charles ,22, 22.1
,#3022.0 ; Vinay Padilla,24,
26.9 ,#4620.0 ;Meredith Santiago, 51 ,
29.3 ,#16330.0; Andre Mccarty,
19,22.7 , #2900.0 ;
Lorena Hodson ,65, 33.1 , #19370.0;
Isaac Vu ,34, 24.8, #7045.0"""
#1
print(medical_data)
Marina Allison ,27 , 31.1 ,
#7010.0 ;Markus Valdez , 30,
22.4, #4050.0 ;Connie Ballard ,43
, 25.3 , #12060.0 ;Darnell Weber
, 35 , 20.6 , #7500.0;
Sylvie Charles ,22, 22.1
,#3022.0 ; Vinay Padilla,24,
26.9 ,#4620.0 ;Meredith Santiago, 51 ,
29.3 ,#16330.0; Andre Mccarty,
19,22.7 , #2900.0 ;
Lorena Hodson ,65, 33.1 , #19370.0;
Isaac Vu ,34, 24.8, #7045.0
#2
updated_medical_data = medical_data.replace("#", "$")
print(updated_medical_data)
Marina Allison ,27 , 31.1 ,
$7010.0 ;Markus Valdez , 30,
22.4, $4050.0 ;Connie Ballard ,43
, 25.3 , $12060.0 ;Darnell Weber
, 35 , 20.6 , $7500.0;
Sylvie Charles ,22, 22.1
,$3022.0 ; Vinay Padilla,24,
26.9 ,$4620.0 ;Meredith Santiago, 51 ,
29.3 ,$16330.0; Andre Mccarty,
19,22.7 , $2900.0 ;
Lorena Hodson ,65, 33.1 , $19370.0;
Isaac Vu ,34, 24.8, $7045.0
#3
num_records = 0
#4
for character in updated_medical_data:
if character == "$":
num_records += 1
#5
print("There are " + str(num_records) + " medical records in the data.")
There are 10 medical records in the data.
#6
medical_data_split = updated_medical_data.split(';')
print(medical_data_split)
['Marina Allison ,27 , 31.1 , \n$7010.0 ', 'Markus Valdez , 30, \n22.4, $4050.0 ', 'Connie Ballard ,43 \n, 25.3 , $12060.0 ', 'Darnell Weber \n, 35 , 20.6 , $7500.0', '\nSylvie Charles ,22, 22.1 \n,$3022.0 ', ' Vinay Padilla,24, \n26.9 ,$4620.0 ', 'Meredith Santiago, 51 , \n29.3 ,$16330.0', ' Andre Mccarty, \n19,22.7 , $2900.0 ', ' \nLorena Hodson ,65, 33.1 , $19370.0', ' \nIsaac Vu ,34, 24.8, $7045.0']
#7
medical_records = []
#8
for record in medical_data_split:
medical_records.append(record.split(','))
print(medical_records)
[['Marina Allison ', '27 ', ' 31.1 ', ' \n$7010.0 '], ['Markus Valdez ', ' 30', ' \n22.4', ' $4050.0 '], ['Connie Ballard ', '43 \n', ' 25.3 ', ' $12060.0 '], ['Darnell Weber \n', ' 35 ', ' 20.6 ', ' $7500.0'], ['\nSylvie Charles ', '22', ' 22.1 \n', '$3022.0 '], [' Vinay Padilla', '24', ' \n26.9 ', '$4620.0 '], ['Meredith Santiago', ' 51 ', ' \n29.3 ', '$16330.0'], [' Andre Mccarty', ' \n19', '22.7 ', ' $2900.0 '], [' \nLorena Hodson ', '65', ' 33.1 ', ' $19370.0'], [' \nIsaac Vu ', '34', ' 24.8', ' $7045.0'], ['Marina Allison ', '27 ', ' 31.1 ', ' \n$7010.0 '], ['Markus Valdez ', ' 30', ' \n22.4', ' $4050.0 '], ['Connie Ballard ', '43 \n', ' 25.3 ', ' $12060.0 '], ['Darnell Weber \n', ' 35 ', ' 20.6 ', ' $7500.0'], ['\nSylvie Charles ', '22', ' 22.1 \n', '$3022.0 '], [' Vinay Padilla', '24', ' \n26.9 ', '$4620.0 '], ['Meredith Santiago', ' 51 ', ' \n29.3 ', '$16330.0'], [' Andre Mccarty', ' \n19', '22.7 ', ' $2900.0 '], [' \nLorena Hodson ', '65', ' 33.1 ', ' $19370.0'], [' \nIsaac Vu ', '34', ' 24.8', ' $7045.0'], ['Marina Allison ', '27 ', ' 31.1 ', ' \n$7010.0 '], ['Markus Valdez ', ' 30', ' \n22.4', ' $4050.0 '], ['Connie Ballard ', '43 \n', ' 25.3 ', ' $12060.0 '], ['Darnell Weber \n', ' 35 ', ' 20.6 ', ' $7500.0'], ['\nSylvie Charles ', '22', ' 22.1 \n', '$3022.0 '], [' Vinay Padilla', '24', ' \n26.9 ', '$4620.0 '], ['Meredith Santiago', ' 51 ', ' \n29.3 ', '$16330.0'], [' Andre Mccarty', ' \n19', '22.7 ', ' $2900.0 '], [' \nLorena Hodson ', '65', ' 33.1 ', ' $19370.0'], [' \nIsaac Vu ', '34', ' 24.8', ' $7045.0']]
#9
medical_records_clean = []
#10
for record in medical_records:
record_clean = []
#11
for item in record:
record_clean.append(item.strip())
#12
medical_records_clean.append(record_clean)
#13
print(medical_records_clean)
[['Isaac Vu', '34', '24.8', '$7045.0', 'Isaac Vu', '34', '24.8', '$7045.0']]
#14 - 15
for record in medical_records_clean:
record[0] = record[0].upper()
#<<<<paso 15
print(record[0])
ISAAC VU
#16
names = []
ages = []
bmis = []
insurance_costs = []
#17
for record in medical_records_clean:
names.append(record[0])
ages.append(record[1])
bmis.append(record[2])
insurance_costs.append(record[3])
#18
print("Names: " + str(names))
print("Ages: " + str(ages))
print("BMI: " + str(bmis))
print("Insurance Costs: " + str(insurance_costs))
Names: ['ISAAC VU']
Ages: ['34']
BMI: ['24.8']
Insurance Costs: ['$7045.0']
#19
total_bmi = 0
#20 - #21
for bmi in bmis:
total_bmi += float(bmi)
average_bmi = total_bmi/len(bmis)
print("Average BMI: " + str(average_bmi))
Average BMI: 24.8
#FINAL...