{"id":2401,"date":"2017-03-08T00:01:51","date_gmt":"2017-03-08T08:01:51","guid":{"rendered":"http:\/\/c-for-dummies.com\/blog\/?p=2401"},"modified":"2017-03-04T09:29:44","modified_gmt":"2017-03-04T17:29:44","slug":"detailed-examination-of-a-csv-file-solution","status":"publish","type":"post","link":"https:\/\/c-for-dummies.com\/blog\/?p=2401","title":{"rendered":"Detailed Examination of a CSV File – Solution"},"content":{"rendered":"

The task for this month’s Exercise<\/a> is to read a CSV file, store the data, then manipulate and report. For my solution, I chose to create an array of structures in which to store the weather information.
\n
\nHere is the nested structure I used in my solution:<\/p>\n

\r\nstruct calendar {\r\n    int year;\r\n    char *month;\r\n    int day;\r\n};\r\nstruct temperature_data {\r\n    struct calendar date;\r\n    float high;\r\n    float low;\r\n};<\/pre>\n
I could have put all the data into a single-level structure, but whenever I see a date as part of the data, I create a nested structure. Above, the calendar<\/code> structure has year<\/code>, month<\/code>, and day<\/code> members. The month<\/code> member is a pointer, which references an array of month strings. It could have easily been a char<\/em> array instead.<\/p>\n
The structure is defined externally, which allows all the program’s various functions to access the temperature_data struct<\/code> variable. In the main()<\/em> function, a structure array is declared:<\/p>\n
struct temperature_data winter[RECORDS];<\/code><\/p>\n
As with last month’s Solution<\/a>, the CSV file is read, but this time its values are stored in the winter[]<\/code> array. The file is closed, and a series of printf()<\/em> statements coupled with various functions generate the required output.<\/p>\n
Here’s sample output from my solution:<\/p>\n
Date range from December 25, 2016 to January 24, 2017:\r\nThe average high was 29.16\r\nThe average low was 14.48\r\nThe highest high was 41.0 on January 20, 2017\r\nThe lowest high was 16.0 on January 3, 2017\r\nThe highest low was 32.0 on January 22, 2017\r\nThe lowest low was -3.0 on January 12, 2017<\/code><\/pre>\n
The first line simply pulls the date from the first and last elements of the winter[]<\/code> array:<\/p>\n
\r\n    printf(\"Date range from %s %d, %d to %s %d, %d:\\n\",\r\n            winter[0].date.month,\r\n            winter[0].date.day,\r\n            winter[0].date.year,\r\n            winter[RECORDS-1].date.month,\r\n            winter[RECORDS-1].date.day,\r\n            winter[RECORDS-1].date.year\r\n            );<\/pre>\n
The RECORDS<\/code> constant is set to 31, the number of records in the weather_data.csv<\/a> file. This first date is found in element zero of the array; the last date is at the value RECORDS<\/code> minus one.<\/p>\n
The next six lines of output rely upon six functions I wrote to manipulate the data:<\/p>\n
\r\nfloat average_high(struct temperature_data w[]);\r\nfloat average_low(struct temperature_data w[]);\r\nint highest_high(struct temperature_data w[]);\r\nint lowest_high(struct temperature_data w[]);\r\nint highest_low(struct temperature_data w[]);\r\nint lowest_low(struct temperature_data w[]);<\/pre>\n
The first two functions calculate the average temperatures for the weather[].high<\/code> and weather[].low<\/code> members of the structure array, represented as w[]<\/code> inside the functions.<\/p>\n
Remember: You must declare the temperature_data<\/code> structure before<\/strong> you prototype the functions!<\/p>\n
The remaining functions crunch the numbers to return the specific element number for the minimum and maximum values as required. The element number is used to generate the output that shows the temperature and date.<\/p>\n
The highest\/lowest functions are pretty basic, with subtle changes between each one to get the specific values. I wrote the first one, highest_high()<\/em>, and then copied-and-pasted it to help create the others.<\/p>\n
To view my entire solution, click here<\/a>. It’s long: 233 lines, but again the final four functions are similar.<\/p>\n
Your solution doesn’t need to be identical to mine. If your output matches the results shown earlier in this post, you’re good.<\/p>\n","protected":false},"excerpt":{"rendered":"
The task for this month’s Exercise is to read a CSV file, store the data, then manipulate and report. For my solution, I chose to create an array of structures in which to store the weather information.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-2401","post","type-post","status-publish","format-standard","hentry","category-solution"],"_links":{"self":[{"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2401"}],"version-history":[{"count":4,"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2401\/revisions"}],"predecessor-version":[{"id":2417,"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2401\/revisions\/2417"}],"wp:attachment":[{"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c-for-dummies.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}