Question: Write a program that reads the provided file station.csv text file for reading. It then scans the file for lines where the DrainageAreaMeasure/MeasureValue column IS

Write a program that reads the provided file station.csvWrite a program that reads the provided file station.csv text file for text file for reading. It then scans the file for lines where the "DrainageAreaMeasure/MeasureValue" column IS NOT EMPTY, and writes those lines out to output file stations-filtered.csv file. Submit your source code and the filtered file. (station.csv file contains data with comma in the double quotes. Use this file, station_cleaned.csvreading. It then scans the file for lines where the "DrainageAreaMeasure/MeasureValue" column for this problem.)

Write a program that reads in the file stations-filtered.csv and computes the average of the "DrainageAreaMeasure/MeasureValue" column and writes it to output file drainage-area-avg.txt

Write a program encodes a text file (a sample fileIS NOT EMPTY, and writes those lines out to output file stations-filtered.csv) using a caesar cipher. It should take as input a shift value from 1-26 and the name of a text file, and write the encoded text to output fileciphertext.txt.To encode the file, add the shift value to the unicode value for each character, INCLUDING punctuation and whitespace. You are not required to decode the ciphertext version, but it does help for testing purposes.

Link to csv file

https://docs.google.com/spreadsheets/d/1o26JfTNobJ_yemrXVhd4qffpAYAZPrHeKLeem4MT3R8/edit?usp=sharing

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!