Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have the first part down for this but after that, I do not know where to go. I cannot use an array or OOP

I have the first part down for this but after that, I do not know where to go. I cannot use an array or OOPimage text in transcribed

Worksheet #6: CSV Data CSC 142 Computer Programming II Due Friday 2/24/2017 Information About Worksheet For this assignment, you will select a CSV data set from the website Data gov, which provides government data. You will write a Java program to load, parse, and filter the data contained in the CSV file for that data set. Visit https://data.gov and scroll down to the "Browse Topics" part of the page. Pick a topic that is interesting to you. Once you click the topic, click the word "Data" in the menu at the top. You will see a list of data sets. Look for a data set that is in CSV format. Java Code for Parsing Data Your Java code should consist of a main method (also called the program driver. The driver will call several static methods that will open the CSV data file, parse a single column from the data contained in the file, and print that column to a new file. Implement a static method copycolumn (string out, int n) that will read data from column n in the CSV data file, and write it out to a new file whose name is contained in the variable out Implement a static method fi ltercolumn (string out, int n that will read data from column n in the CSV data file, filter the data based on a criteria passed as the third argument (see below), and write the data to a new file whose name is contained in the variable out. The third argument will depend on the type of data you are filtering: If your columns contain numerical data, pass a double parameter called "max" and have your method only copy values from the column that are less than the maximum. If your columns contain labels or String data, pass a String parameter called "matchThis" and have your method only copy values from the column that contain the String match This. Instructions Complete a cover page in a word processor that answers the two questions above. Attach any Java code that you wrote to answer the questions, and submit these using the Worksheet 6 assignment on Canvas

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman

13th Edition

0134773659, 978-0134773650

More Books

Students also viewed these Databases questions