Solved by verified expert:One of the fundamental requirements of programs is to use data stored in permanent storage such as a hard disk file. Programs must be able to read and write this type of data and use appropriate data structures within the program to work with the data. In this assignment, you will write a program to load and manipulate a data file. The data file can be downloaded from the following link: data1.csvThe file should not be a comma delimited file and should have the following record structure:FirstName – Character – Size (12)LastName – Character – Size (16)Company – Character – Size (32)Address – Character – Size (32)City – Character – Size (24)County – Character – Size (24)State – Character – Size (2)ZIP – Number – Size (5)Phone – Character – Size (12)Fax – Character – Size (12)Email – Character – Size (32)Web – Character – Size (42)Step 1: For this assignment, you will write a complete Java console program to load the data file into an ArrayList data structure. Store each line from the file as a separate record in the ArrayList. To read the file, you should use a FileReader wrapped in a BufferedReader. If you create a Java class to contain each record, you will be able to create an object for each record and store the object in the ArrayList. Sorting the data can then be done using another wrapper class that contains the ArrayList and has methods for sorting and output of the data.Step 2: After the file is loaded into the ArrayList, sort the data in ascending order based on the LastName field, and display the following fields:First nameLast nameCompanyStep 3: Next, sort the data in descending order based on the ZIP field, and display the following fields:First nameLast nameCompanyZIPStep 4: Display all of the records (and all of the fields) for everyone that is in the state “NY.”Step 5: The submission should be a single MS Word document with the program source code for the solution and screenshots of the output for the following list:Sorted data based on last nameSorted data based on ZIPEveryone in the state of NY
data1.xlsx
Unformatted Attachment Preview
FirstName LastName Company Address City
County
State
Eddie
Vazquez Osweep Industries
14316 Hancock
Richdale
Circle AnchorageAK
Chris
Robinson Finch Products
2133 N West
Deerford
Street Maricopa AZ
Brooklynn Taylor
Prism Globe48Inc
E 13th Blvd
Corway Hills
New York NY
Zion
Miller
Switch Pen196
Company
State Ave
LawnworthMiddlesex NJ
Ruby
Flynn
Snap Sun Services
3175 W Carrier
Meadowburg
Lane Honolulu HI
Bob
Lewis
Code Planet22652
Properties
E Easton
East Fortview
St
WillLake IL
Susan
HernandezLight Table 9630
Bearings
S CityKingstown
Ave
Maricopa
Reservoir AZ
Vicky
Perez
Lime Cake Records
7421 Jefferson
Hearthbridge
Pkwy Lehigh
PA
Lee
Hill
Round Rock884
Engineers
W Glendale
Old Lindenfield
Rd Los Angeles
Grove CA
Mary
Edwards Simple Byte6122
Technologies
E BlueUpper
Vine Prkwy
Caldbrook
Orange FL
Jennifer Davis
Quicker Span
2598
Reviews
Oak Rd
East Maymeadow
Shelby
TN
Michelle Martin
Diamond Post
329Surveys
Brush Cir
Belcove
NW
Marion OR
Conner
Lee
Cash Pad Loans
116 Rail Way
AdamsfieldMahoning OH
Colin
Brown
Easy Rug Cleaners
1612 W BayBridgeing
Rd
Orange CA
Sheila
Garcia
Clear Blue Window
152 Broad
Cleaning
Ln
Portcroft Cove
Bexar
TX
Rosy
King
Shots Manufacturing
6930 Bass Stream
Old Clarksfax
BlvdHennepin MN
David
Baker
Box State Trading
6728 Timbuck
Corporation
Pittsfort
St
Mahoning OH
Willa
Roberts Low Sky Seating
1519 Company
HawkColeford
Ave
El Paso
TX
Tiana
Williams Country Boxes
24969 TibbsChristiansmount
Circle Los AngelesCA
Douglas Ingram
Quicker Cupcakes
3450 Lion Rd
BrunsbeachNueces TX
Colt
Lopez
Case Electronics
370 Stock Ave
Fort Hansville
Middlesex NJ
Stephen Phillips
Brown Technologies
1095 SW 2nd
New
RdHamford
Vanderburgh
IN
Catherine Smith
Side Sauce 140
Spices
E 4th Street
Hempline Island
New York NY
Calvin
Morris
Zippy Sandwiches
79 W Broadway
Bayway
Ave Franklin OH
ZIP
99515
85004
10001
8861
96819
60410
85051
18087
91790
32809
38112
97302
44512
92802
78205
55428
44406
79925
91355
78408
8861
47713
10018
43215
Phone
Fax
907-456-8510
907-456-2326
602-141-3716
602-141-2898
212-778-6886
212-778-6875
732-331-5270
732-331-4107
808-947-7855
808-947-7119
815-356-3760
815-356-1330
602-842-3864
602-842-4662
610-284-7632
610-284-5884
626-849-7849
626-849-2614
407-746-3200
407-746-1395
901-438-6447
901-438-4022
503-260-7108
503-260-7000
330-869-4252
330-869-4647
714-661-3939
714-661-2748
210-340-4128
210-340-1086
763-426-3083
763-426-2774
330-644-7457
330-644-9322
915-660-1619
915-660-4618
661-368-4194
661-368-1035
361-773-7322
361-773-2874
732-553-9625
732-553-2886
812-310-3693
812-310-6514
212-830-5063
212-830-8652
614-114-7890
614-114-5010
Email
Web
Convert to Pig Latin
eddie@vazquez.com
http://www.eddievazquez.com
The Customer’s Name is Eddie Vazquez and they work for Osweep Industries
chris@robinson.com
http://www.chrisrobinson.com
The Customer’s Name is Chris Robinson and they work for Finch Products
brooklynn@taylor.com
http://www.brooklynntaylor.com
The Customer’s Name is Brooklynn Taylor and they work for Prism Globe Inc
zion@miller.com
http://www.zionmiller.com
The Customer’s Name is Zion Miller and they work for Switch Pen Company
ruby@flynn.com
http://www.rubyflynn.com
The Customer’s Name is Ruby Flynn and they work for Snap Sun Services
bob@lewis.com
http://www.boblewis.com
The Customer’s Name is Bob Lewis and they work for Code Planet Properties
susan@hernandez.com
http://www.susanhernandez.com
The Customer’s Name is Susan Hernandez and they work for Light Table Bearings
vicky@perez.com
http://www.vickyperez.com
The Customer’s Name is Vicky Perez and they work for Lime Cake Records
lee@hill.com
http://www.leehill.com
The Customer’s Name is Lee Hill and they work for Round Rock Engineers
mary@edwards.com
http://www.maryedwards.com
The Customer’s Name is Mary Edwards and they work for Simple Byte Technologies
jennifer@davis.com
http://www.jenniferdavis.com
The Customer’s Name is Jennifer Davis and they work for Quicker Span Reviews
michelle@martin.com
http://www.michellemartin.com
The Customer’s Name is Michelle Martin and they work for Diamond Post Surveys
conner@lee.com
http://www.connerlee.com
The Customer’s Name is Conner Lee and they work for Cash Pad Loans
colin@brown.com
http://www.colinbrown.com
The Customer’s Name is Colin Brown and they work for Easy Rug Cleaners
sheila@garcia.com
http://www.sheilagarcia.com
The Customer’s Name is Sheila Garcia and they work for Clear Blue Window Cleaning
rosy@king.com
http://www.rosyking.com
The Customer’s Name is Rosy King and they work for Shots Manufacturing
david@baker.com
http://www.davidbaker.com
The Customer’s Name is David Baker and they work for Box State Trading Corporation
willa@roberts.com
http://www.willaroberts.com
The Customer’s Name is Willa Roberts and they work for Low Sky Seating Company
tiana@williams.com
http://www.tianawilliams.com
The Customer’s Name is Tiana Williams and they work for Country Boxes
douglas@ingram.com
http://www.douglasingram.com
The Customer’s Name is Douglas Ingram and they work for Quicker Cupcakes
colt@lopez.com
http://www.coltlopez.com
The Customer’s Name is Colt Lopez and they work for Case Electronics
stephen@phillips.com
http://www.stephenphillips.com
The Customer’s Name is Stephen Phillips and they work for Brown Technologies
catherine@smith.com
http://www.catherinesmith.com
The Customer’s Name is Catherine Smith and they work for Side Sauce Spices
calvin@morris.com
http://www.calvinmorris.com
The Customer’s Name is Calvin Morris and they work for Zippy Sandwiches
…
Purchase answer to see full
attachment
