Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this is the contents of the Assign_5_data.txt file mentioned above Jane 97 Luke 26 Luke 8 Luke 57 Wyatt 75 Nora 60 Zela 22 Jane
this is the contents of the "Assign_5_data.txt" file mentioned above
Jane 97 Luke 26 Luke 8 Luke 57 Wyatt 75 Nora 60 Zela 22 Jane 95 Sally 47 Sally 23 Wyatt 70 Jake 44 Jake 84 Nora 1 Oliva 54 Wyatt 89 Jane 25 Jake 68 Oliva 88 Alice 26 Alice 59 Sally 63 Alice 43 Sally 41 Nora 78 Zela 35 Zela 87 Wyatt 40 Sally 10 Oliva 52 Jane 51 Bob 53 Alice 88 Nora 3 Jane 1 Zela 50 Zela 51 Bob 27 Bill 28 Zela 34 Nora 57 Alice 51 Luke 36 Oliva 100 Oliva 39 Bob 90 Jake 91 Zela 50 Oliva 68 Luke 53 Oliva 61 Luke 80 Nora 92 Steve 94 Oliva 82 Sally 85 Bob 2 Sally 82 Jake 4 Sally 21 Bill 12 Alice 62 Luke 68 Bill 23 Zela 28 Alice 14 Jane 62 Alice 70 Nora 84 Jake 53 Nora 56 Jake 19 Bill 94 Zela 71 Jane 51 Jake 77 Nora 80 Bob 60 Luke 52 Zela 26 Jake 64 Jake 55 Sally 30 Luke 67 Steve 35 Luke 10 Zela 43 Wyatt 32 Bob 83 Bill 55 Wyatt 50 Alice 32 Jake 59 Jane 51 Jake 21 Alice 11 Jake 96 Jake 66 Wyatt 68 Jake 1 Oliva 1 Wyatt 12 Wyatt 49 Jake 46 Sally 86 Sally 93 Oliva 24 Oliva 53 Alice 62 Sally 64 Luke 32 Alice 86 Sally 24 Zela 32 Steve 82 Oliva 98 Oliva 75 Wyatt 6 Wyatt 40 Wyatt 77 Steve 92 Alice 16 Wyatt 31 Zela 86 Jake 97 Alice 8 Steve 27 Jake 23 Bill 89 Bob 66 Bill 61 Luke 47 Nora 23 Luke 44 Bob 100 Wyatt 69 Nora 71 Luke 24 Nora 23 Jake 86 Luke 49 Luke 6 Bob 14 Luke 49 Oliva 74 Wyatt 56 Steve 39 Sally 5 Zela 19 Alice 15 Jake 6 Steve 100 Jake 95 Jane 76 Jake 16 Sally 63 Nora 41 Jake 6 Wyatt 47 Sally 61 Jake 99 Bob 39 Nora 52 Sally 68 Bill 9 Sally 30 Bill 96 Jane 41 Wyatt 76 Wyatt 88 Zela 31 Alice 46 Wyatt 52 Jake 53 Wyatt 70 Steve 47 Steve 56 Bill 39 Jake 23 Wyatt 93 Oliva 28 Alice 64 Oliva 45 Sally 1 Sally 81 Alice 47 Oliva 6 Oliva 46 Oliva 84 Nora 90 Wyatt 41 Bob 77 Steve 44 Oliva 82 Sally 80 Bill 32 Bob 31 Jake 27 Wyatt 93 Bill 18 Steve 56 Steve 14 Alice 11 Bill 2 Sally 60 Bob 86 Wyatt 93 Bill 74 Sally 31 Nora 39 Sally 77 Jane 3 Jane 78 Zela 16 Bill 32 Nora 11 Jake 33 Nora 25 Sally 20 Wyatt 88 Bob 75 Jane 62 Oliva 99 Oliva 85 Bob 21 Wyatt 46 Wyatt 27 Steve 6 Zela 23 Bob 66 Oliva 97 Jake 36 Jake 70 Luke 31 Steve 21 Alice 61 Nora 11 Zela 6 Oliva 12 Alice 24 Sally 90 Wyatt 53 Luke 65 Zela 67 Oliva 52 Zela 63 Jake 25 Wyatt 84 Wyatt 38 Bill 20 Jake 30 Jane 50 Oliva 27 Sally 71 Sally 76 Jake 13 Jane 10 Alice 53 Sally 4 Oliva 49 Oliva 52 Nora 44 Bob 49 Steve 76 Jake 85 Zela 97 Jake 75 Bill 81 Bob 41 Luke 98 Wyatt 46 Alice 41 Bob 82 Zela 87 Jake 60 Oliva 82 Zela 27 Luke 99 Luke 65 Luke 55 Zela 96 Jake 44 Bill 14 Oliva 84 Bill 51 Wyatt 4 Bill 63 Wyatt 65 Oliva 86 Jane 26 Jake 30 Jane 2 Alice 83 Bob 22 Jake 43 Luke 9 Jake 91 Nora 9 Oliva 76 Oliva 96 Steve 45 Sally 27 Jake 69 Jake 21 Jane 71 Nora 76 Luke 42 Jake 23 Wyatt 50 Alice 72 Bill 45 Jake 29 Steve 61 Oliva 31 Wyatt 64 Jane 66 Bob 1 Nora 44 Steve 78 Zela 29 Oliva 40 Zela 30 Steve 17 Bob 42 Steve 70 Wyatt 83 Steve 30 Nora 24 Luke 31 Bob 92 Sally 33 Luke 65 Bill 80 Luke 65 Bill 48 Zela 91 Oliva 81 Zela 62 Jane 20 Jane 73 Jane 65 Jake 33 Sally 7 Alice 14 Nora 68 Jake 26 Oliva 28 Luke 85 Bob 90 Oliva 46 Oliva 99 Luke 98 Sally 65 Sally 2 Sally 78 Zela 82 Luke 89 Steve 77 Jake 80 Zela 2 Sally 68 Oliva 44 Nora 70 Jake 26 Bob 39 Jane 23 Zela 47 Zela 7 Bob 52 Steve 9 Luke 38 Jane 97 Zela 96 Oliva 18 Luke 100 Nora 10 Bill 31 Wyatt 5 Zela 94 Bob 35 Jane 9 Oliva 15 Jane 73 Bob 100 Luke 13 Sally 38 Oliva 45 Nora 93 Steve 44 Alice 68 Luke 5 Bob 33 Alice 69 Jake 69 Bob 89 Nora 20 Sally 64 Jake 36 Nora 47 Bob 77 Steve 97 Wyatt 40 Nora 84 Bill 95 Wyatt 78 Luke 51 Bill 79 Bill 39 Nora 49 Sally 87 Jane 30 Nora 94 Sally 73 Bill 83 Sally 50 Bob 40 Nora 39 Bill 59 Jake 42 Wyatt 69 Nora 37 Sally 26 Oliva 47 Jane 30 Zela 63 Oliva 73 Alice 88 Bob 72 Bill 53 Alice 55 Luke 11 Wyatt 25 Wyatt 70 Jane 79 Steve 18 Bob 63 Jane 53 Jane 55 Jane 70 Bob 12 Jake 18 Bob 32 Jake 98 Sally 66 Sally 63 Oliva 11 Jake 59 Luke 30 Jake 94 Sally 4 Jake 33 Bill 38 Jake 94 Bob 57 Sally 57 Bill 42 Bill 31 Zela 3 Steve 22 Oliva 49 Luke 32 Jake 11 Bill 21 Steve 56 Jake 11 Oliva 77 Bob 16 Jake 5 Zela 47 Jake 70 Jake 98 Jake 52 Nora 98 Jake 35 Jane 6 Zela 91 Luke 14 Nora 33 Luke 96 Jake 69 Jake 6 Bob 35 Jane 62 Sally 62 Wyatt 12 Bill 30 Alice 68 Bob 77 Wyatt 23 Alice 17 Jake 25 Jake 4 Bob 80 Bob 29 Wyatt 36 Alice 90 Luke 59 Oliva 45 Jake 43 Zela 76 Nora 43 Zela 81 Jake 35 Steve 18 Bob 6 Zela 78 Luke 27 Oliva 61 Wyatt 46 Wyatt 37 Luke 7 Oliva 86 Alice 68 Zela 36 Luke 14 Wyatt 97 Bob 26 Jane 92 Alice 48 Alice 61 Nora 39 Nora 70 Jake 55 Steve 58 Luke 38 Steve 50 Nora 27 Wyatt 46 Luke 79 Jake 37 Sally 48 Sally 26 Steve 44 Bob 56 Jane 36 Jake 18 Jake 51 Jake 6 Bob 78 Bob 65 Steve 12 Jake 90 Bill 57 Zela 62 Nora 56 Sally 62 Wyatt 53 Oliva 81 Bill 62 Alice 59 Jake 13 Sally 6 Oliva 52 Alice 48 Jake 38 Luke 64 Alice 64 Bill 81 Bill 83 Zela 57 Jane 31 Jane 61 Nora 30 Bill 82 Jake 47 Jake 18 Zela 26 Jake 88 Jane 51 Jane 22 Alice 26 Wyatt 64 Nora 35 Luke 12 Jane 96 Oliva 18 Sally 69 Bill 34 Luke 51 Luke 43 Bill 8 Oliva 4 Jane 33 Nora 68 Wyatt 41 Steve 52 Jake 60 Bob 27 Alice 76 Bob 21 Nora 54 Steve 85 Wyatt 40 Bill 88 Nora 33 Alice 83 Jane 93 Steve 71 Luke 34 Zela 18 Jake 41 Steve 99 Zela 61 Jane 71 Bill 65 Luke 10 Jake 76 Bob 18 Bob 72 Sally 57 Jane 22 Alice 67 Luke 73 Oliva 96 Sally 58 Zela 55 Nora 90 Oliva 29 Bill 48 Wyatt 79 Jake 28 Luke 25 Jake 42 Jake 16 Jake 7 Zela 3 Bob 86 Bill 63 Jake 5 Bob 92 Bill 45 Bob 52 Alice 60 Alice 78 Wyatt 24 Alice 4 Zela 55 Wyatt 73 Jane 3 Jake 58 Luke 41 Nora 68 Steve 19 Oliva 83 Alice 10 Sally 69 Sally 53 Sally 32 Jake 55 Sally 7 Wyatt 47 Nora 39 Nora 65 Steve 28 Oliva 83 Alice 61 Bob 36 Steve 96 Bob 35 Bill 20 Zela 70 Bob 17 Zela 88 Luke 2 Oliva 80 Zela 70 Steve 1 Jane 59 Zela 67 Nora 90 Zela 35 Jake 2 Jake 7 Nora 49 Sally 81 Jake 32 Jake 93 Zela 27 Zela 99 Jane 58 Jake 52 Luke 70 Jake 14 Bob 60 Sally 50 Steve 49 Jake 54 Jake 16 Jake 43 Jake 52 Nora 37 Steve 31 Bill 55 Luke 40 Oliva 8 Jane 27 Bill 42 Oliva 98 Oliva 51 Bill 54 Wyatt 11 Jane 60 Steve 35 Jake 53 Sally 23 Steve 93 Alice 100 Zela 93 Zela 75 Nora 72 Jake 3 Jake 53 Jake 50 Sally 86 Steve 10 Sally 45 Jane 83 Zela 36 Bob 6 Bob 49 Jake 7 Bill 71 Luke 94 Jane 4 Bob 59 Bob 10 Bob 93 Bill 22 Steve 37 Wyatt 90 Wyatt 92 Jake 57 Jake 2 Jake 49 Jane 95 Oliva 49 Jake 55 Luke 66 Jane 31 Alice 84 Alice 92 Sally 35 Zela 4 Luke 31 Bob 88 Nora 14 Bill 79 Wyatt 75 Bob 26 Nora 91 Oliva 7 Steve 60 Bob 12 Wyatt 60 Alice 77 Jane 80 Sally 74 Zela 10 Jane 38 Oliva 75 Alice 27 Zela 15 Wyatt 47 Jake 28 Luke 18 Wyatt 49 Oliva 40 Wyatt 50 Wyatt 43 Jane 31 Bob 62 Zela 49 Alice 54 Jake 5 Jane 25 Nora 84 Luke 46 Luke 94 Sally 93 Wyatt 59 Bob 64 Luke 22 Luke 56 Oliva 42 Jane 21 Bob 53 Zela 43 Sally 45 Bob 77 Zela 5 Bob 72 Nora 82 Oliva 7 Bob 58 Oliva 50 Luke 5 Steve 56 Zela 82 Jake 56 Jake 12 Sally 52 Jake 89 Steve 49 Bill 6 Wyatt 36 Wyatt 64 Luke 70 Jane 3 Nora 68 Bill 5 Alice 86 Alice 81 Bob 59 Steve 45 Bob 28 Bill 16 Alice 43 Wyatt 91 Jake 28 Bob 42 Jake 9 Oliva 9 Wyatt 86 Sally 66 Alice 99 Zela 93 Jake 92 Jake 97 Jane 60 Zela 88 Oliva 10 Jake 43 Steve 30 Wyatt 36 Jane 35 Jane 29 Oliva 23 Jane 100 Sally 41 Jake 23 Jake 51 Bill 72 Bob 20 Alice 50 Wyatt 66 Steve 42 Bob 38 Jane 99 Wyatt 95 Steve 38 Nora 42 Alice 62 Alice 29 Bob 53 Jane 77 Steve 11 Jane 94 Bill 34 Wyatt 40 Jake 60 Jake 82 Nora 50 Nora 75 Nora 14 Luke 71 Steve 58 Sally 48 Oliva 59 Jake 71 Zela 21 Jake 22 Sally 79 Jane 13 Zela 38 Jane 57 Wyatt 44 Jake 92 Luke 58 Jake 91 Bob 95 Nora 30 Alice 24 Oliva 13 Jake 3 Luke 34 Zela 76 Sally 20 Bob 87 Luke 28 Jake 41 Oliva 57 Bill 27 Luke 9 Zela 15 Oliva 22 Alice 45 Jake 49 Luke 23 Alice 97 Jake 38 Zela 14 Jane 97 Wyatt 56 Oliva 83 Jake 52 Zela 92 Bob 100 Bob 54 Zela 33 Jake 54 Alice 45 Nora 96 Oliva 33 Steve 45 Bob 56 Alice 94 Bill 8 Zela 74 Zela 65 Wyatt 20 Jane 31 Wyatt 67 Bob 55 Alice 92 Steve 58 Wyatt 57 Bob 58 Oliva 28 Zela 9 Sally 78 Jake 68 Bob 100 Jane 61 Nora 29 Bill 71 Jake 94 Bill 30 Jane 27 Luke 7 Bill 72 Bob 49 Wyatt 60 Bob 14 Sally 2 Bill 85 Luke 43 Oliva 12 Alice 76 Oliva 36 Luke 66 Jake 88 Luke 100 Jane 92 Oliva 24 Bill 55 Bob 11 Wyatt 54 Sally 44 Zela 6 Steve 94 Steve 86 Zela 76 Jane 53 Jane 44 Jake 7 Wyatt 7 Nora 40 Bill 41 Bob 26 Zela 86 Bob 22 Bill 89 Alice 91 Luke 18 Steve 7 Oliva 76 Nora 97 Bill 68 Zela 91 Oliva 84 Jake 12 Bill 19 Bob 38 Jane 94 Oliva 98 Alice 79 Jake 22 Jake 20 Bill 50 Wyatt 35 Bill 63 Sally 44 Bill 67 Jake 20 Wyatt 78 Jake 4 Luke 84 Jake 24 Sally 77 Steve 31
please use python 3 for the program
Assignment 5 In this assignment you are given a file "Assign_5_data.txt" that is formated as follows: on each line the first non blank string is a name, then some spaces and then an string of digits, which represents an amount. A name will appear on many different lines. A short example would be the following file contents: Bill 78 Jane 91 Steve 90 Bill 18 Jane 17 Bill 81 Write a program that reads this file, and for every name adds together the numbers on all the lines starting with the name. Write this information to the output file "Assign_6_amounts.txt" where each line contains a name, followed by some space, followed by the total for that name, followed by a newline character " ". Write the names in alphabetrical order. For example if the input file is the short example above, the output file would read Bill 177 Jane 108 Steve 90 Do not worry about lining up columns in the output fileStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started