File Processing

Please download the Sacramentorealestatetransactions.csv file from the Files section of your canvas course page.

Write a program that would read the csv file. Write the following information onto a separate txt file for only the houses that are priced greater than $500,000.

StreetAddress City Sqft Price

(Hint: Use a line scanner to extract required information from each line. Use two file pointers, one for reading from the source CSV file and the other to handle the output file)

state bedsbaths qtype latitude longitude 836 Residentia Wed May 59222 38.63191-121.435 1167 Residentia Wed May 68212 38.4789 -121.431 796 Residentia Wed May 68880; 38.61831 -121.444 852 Residentia Wed May 69307 38.61684 -121.439 797 Residentia Wed May 81900 38.51947-121.436 1122 Condo Wed May 89921 38.6626 -121.328 1104 Residentia Wed May 90895 38.68166-121.352 1177 Residentia Wed May 91002 38.53509-121.481 941 Condo Wed May 94905 38.62119 -121.271 1146 Residentia Wed May 98937 38.70091 -121.443 909 Residentia Wed May 100309 38.63766 -121.452 1289 Residentia Wed May 106250 38.47075-121.459 871 Residentia Wed May 106852 38.6187-121.436 1020 Residentia Wed May 107502 38.48222121.493 1022 Residentia Wed May 108750 38.67291-121.359 1134 Condo Wed May 110700 38.70005-121.35:1 844 Residentia Wed May 113263 38.68959-121.452 795 Condo Wed May 116250 38.67978 -121.314 588 Residentia Wed May 120000 38.6121-121.469 1356 Residentia Wed May 121630 38.69-121.463 1118 Residentia Wed May 122000 38.70785121.321 1329 Residentia Wed May 122682 38.46817-121.444 sale_date price 1 street city 2 3526 HIGHSACRAME 95838 CA 3 51 OMAH SACRAME 95823 CA 4 2796 BRAN SACRAME 95815 CA 5 2805 JANE SACRAME 95815 CA 6 6001 MCMSACRAME 95824 CA 7 5828 PEPP SACRAME 95841 CA 8 6048 OGD SACRAME 95842 CA 9 2561 19THSACRAME 95820 CA 10 11150 TRIIRANCHO 95670 CA 11 7325 10TH RIO LINDA 95673 CA 12 645 MORF SACRAME 95838 CA 13 4085 FAW SACRAME 95823 CA 14 2930 LA R(SACRAME 95815 CA 15 2113 KIRK SACRAME 95822 CA 16 4533 LOCHSACRAME 95842 CA 17 7340 HAMSACRAME 95842 CA 18 6715 6TH RIO LINDA 95673 CA 19 6236 LONCITRUS HE 95621 CA 20 250 PERALSACRAME 95833 CA 21 113 LEEWIRIO LINDA 95673 CA 22 6118 STONCITRUS HE 95621 CA 23 4882 BANISACRAME 95823 CA zip