In this assignment you will read through and parse a file with text and numbers. You will extract all the numbers in the file and compute the sum of the numbers.
Data FilesWe provide two files for this assignment. One is a sample file where we give you the sum for your testing and the other is the actual data you need to process for the assignment.
- Sample data: http://py4e-data.dr-chuck.net/regex_sum_42.txt (There are 90 values with a sum=445833)
- Actual data: http://py4e-data.dr-chuck.net/regex_sum_232111.txt (There are 57 values and the sum ends with 389)
Why should you learn to write programs? 7746
12 1929 8827
Writing programs (or programming) is a very creative
7 and rewarding activity. You can write programs for
many reasons, ranging from making your living to solving
8837 a difficult data analysis problem to having fun to helping 128
someone else solve a problem. This book assumes that
everyone needs to know how to program ...
The sum for the sample text above is 27486. The numbers can appear anywhere in the line. There can be any number of numbers in each line (including none).Handling The DataThe basic outline of this problem is to read the file, look for integers using the re.findall(), looking for a regular expression of '[0-9]+' and then converting the extracted strings to integers and summing up the integers.
Turn in Assignent
and plz check my code below:
file = open('regex_sum_232111.txt', 'r')
sum = 0
for line in file:
numbers = re.findall('[0-9]+', line)
for number in numbers:
sum = sum + int(number)
Moved to the Data Science forum by @Laura
Best answer by THANGA MANICKAM M
Because your code for the Actual data sums the numbers which are part of a word also.
In the line "http://www.py4e.com/code3/" in the actual data 4 and 3 are also added during the summation. But they are just part of the URL and not space separate random integers.
Another example is in line,
"you consult www.py4e.com where " . Here 4 is considered during summation though it is part of a word and not a separate integer.
Example for a space separate integer is in line,
"Writing 6778 programs 5780 ".
Clarify this with assignment section whether only space separated integers should be considered. If so, then consider changing regex pattern in such a way that only integers which have a space or newline on both the sides are considered for summing .
I hope this helps.