Question

Using python beginner code see example code of what to use for this assignment

we have gathered together some interesting data into a file called harvardLightning.txt

The file contains all recorded lightning strikes in the harvard area

Parsing

Review alist = str.split()                  # alist will contain the elements of str - split using whitespace

Specifying a delimiter

Examples: delimiter = ',' delimiter = '-', delimiter = ';'

Stripping specified characters

Example: astring.strip('\n')

Avoid blank lines: if len(line) == 0:

                                             continue

Splitting on commas

Your task is to extract the dates and the corresponding number of lightning strikes

2014-04-10 :   1 lightning strikes were recorded.

2014-04-21 :   19 lightning strikes were recorded.

                              *

                              *            

                              *

2014-09-03 :   102 lightning strikes were recorded.

See if you can output the data with a more familiar date format:

(Hint: split the date and rearrange the elements)

04 10 2014 : 1 lightning strikes were recorded.

04 21 2014 : 19 lightning strikes were recorded.

Please use the following above code and comments to write this code

File sample :

DAY,CENTERLAT,CENTERLON,FCOUNT
2015-04-10,42.7,-73.8,1
2015-04-21,42.7,-73.8,19
2015-05-10,42.7,-73.8,1
2015-05-27,42.7,-73.8,7
2015-05-30,42.7,-73.8,7
2015-06-09,42.7,-73.8,99
2015-06-12,42.7,-73.8,34
2015-06-13,42.7,-73.8,276
2015-06-23,42.7,-73.8,5
2015-07-19,42.7,-73.8,110
2015-08-03,42.7,-73.8,62
2015-08-04,42.7,-73.8,3
2015-08-11,42.7,-73.8,3
2015-08-15,42.7,-73.8,45
2015-09-03,42.7,-73.8,102

The code needs to be as simple as possible using the above example code as reference. It cannot be code that we havent covered in class. so no import, def load

Answer 1

hey here is solution to your problem.

#opening csv file
with open("file.txt", "r") as ins:
    # lines array to store all the lines of file
    lines = []
    # now looping through each line
    for line in ins:
       #appending each line to the lines array with removing last char of each line
       #because its a "\n" newline char which isnot needed

        lines.append(line[:-1])

# now looping through each line in lines array to print the output
for i in lines:
  
   # splitting each line by "," delimeter so we get seperated arraylist of elements
   temp=i.split(",")
   #data inside temp ['2015-07-19', '42.7', '-73.8', '110']
   count_of_lightning=temp[3]
   #splitting the date attribute so we can reshuflle date to year month date to month date year format
   temp_date=temp[0].split("-")
   # ['2015', '09', '03'] data inside temp_Date variable
   # set date as "month date year"

   #printing final output
   # month date year lightning count
   print (temp_date[1]+" "+temp_date[2 ]+" "+temp_date[0]+ " : "+count_of_lightning + " lightning strikes were recorded.")

In case of any doubt please comment. Happy Learning :)