Python!! Data Mining Project!
Need help with this programming assignment!
Programming Project 06 Data Mining Google Stock Assignment Overview The goal of this project is to gain more practice with file l/O, lists and functions Background Data mining is the process of sorting through large amounts of data and picking out relevant information. It is usually used by business intelligence organizations, and financial analysts, but is increasingly being used in the sciences to extract information from the enormous data sets generated by modern experimental and observational methods. (from wikipedia: http://en.wikipedia.org/wiki/Datamining) In this project, we want to do some preliminary data mining to the prices of Google stock Your program will calculate the monthly average prices of Google stock from 2004 to 2008, and tell us the 6 best and 6 worst months for Google Project Specifications 1. A file of Google stock's historical prices will be given to you, whose name is table.csv. This file could be opened by notepad or wordPad, and is delimited by comma Date, Open, High, Low, Close, Volume, Adj Close 2008-09-19,461.00, 462.07,443.28, 449.15,10006000,449.15 2008-09-18,422.64,439.18,410.50,439.08,8589400,439.08 2008-09-17,438.48,439.14,413.44,414.49,9126900,414.49 2008-09-16,425.96, 449.28,425.49,442.93, 6990700,442.93 If you open it with Excel, comma will not be shown 2. In addition to main() you need to write the following functions a. get data_list(file name) In this function, you are required to read the file of stock's historical prices. You should use file_name instead of hard code "table.csv" in this function, that way if we wanted to use a differet table at any time we could just change the call to the function and not have to change the function itself. After reading each line, you will split it into a list, and append this list to another main list, suppose its name is "data_list". So, data list is a list of lists, a.k.a. 2- D list. At the end of this function, return data_list b. get monthly_averages(data_list) In this function, you will use the data _list generated by the first function as the parameter. Use Date, Volume, and Adj Close to calculate the average monthly prices How to calculate the average price? Suppose one day's volume and close price are V1 and C1 respectively, then that day's total sales equals V1 * C1. We will use the "Volume" column for the day's volume and the "Adj. Close" column for the day's close. Now suppose another Programming Project 06 Data Mining Google Stock Assignment Overview The goal of this project is to gain more practice with file l/O, lists and functions Background Data mining is the process of sorting through large amounts of data and picking out relevant information. It is usually used by business intelligence organizations, and financial analysts, but is increasingly being used in the sciences to extract information from the enormous data sets generated by modern experimental and observational methods. (from wikipedia: http://en.wikipedia.org/wiki/Datamining) In this project, we want to do some preliminary data mining to the prices of Google stock Your program will calculate the monthly average prices of Google stock from 2004 to 2008, and tell us the 6 best and 6 worst months for Google Project Specifications 1. A file of Google stock's historical prices will be given to you, whose name is table.csv. This file could be opened by notepad or wordPad, and is delimited by comma Date, Open, High, Low, Close, Volume, Adj Close 2008-09-19,461.00, 462.07,443.28, 449.15,10006000,449.15 2008-09-18,422.64,439.18,410.50,439.08,8589400,439.08 2008-09-17,438.48,439.14,413.44,414.49,9126900,414.49 2008-09-16,425.96, 449.28,425.49,442.93, 6990700,442.93 If you open it with Excel, comma will not be shown 2. In addition to main() you need to write the following functions a. get data_list(file name) In this function, you are required to read the file of stock's historical prices. You should use file_name instead of hard code "table.csv" in this function, that way if we wanted to use a differet table at any time we could just change the call to the function and not have to change the function itself. After reading each line, you will split it into a list, and append this list to another main list, suppose its name is "data_list". So, data list is a list of lists, a.k.a. 2- D list. At the end of this function, return data_list b. get monthly_averages(data_list) In this function, you will use the data _list generated by the first function as the parameter. Use Date, Volume, and Adj Close to calculate the average monthly prices How to calculate the average price? Suppose one day's volume and close price are V1 and C1 respectively, then that day's total sales equals V1 * C1. We will use the "Volume" column for the day's volume and the "Adj. Close" column for the day's close. Now suppose another
