@@ -1,8 +1,12 @@
-name,shares,price
-"AA",100,32.20
-"IBM",50,91.10
-"CAT",150,83.44
-"MSFT",200,51.23
-"GE",95,40.37
-"MSFT",50,65.10
-"IBM",100,70.44
+name,shares,price
+AA,100,32.2
+IBM,50,91.1
+CAT,150,83.44
+MSFT,200,51.23
+GE,95,40.37
+MSFT,50,65.1
+IBM,100,70.44
+ROKU,50,134.56
+JPM,50,93.45
+BAC,206,23.54
+DFKG,182,37.45
@@ -1,16 +1,5 @@
-# pcost.py
-# Exercise 1.27: Reading a data file
-#
-# Now that you know how to read a file, let’s write a program to perform a simple calculation.
-#
-# The columns in portfolio.csv correspond to the stock name, number of shares, and purchase price of a single stock
-# holding. Write a program called pcost.py that opens this file, reads all lines, and calculates how much it cost to
-# purchase all of the shares in the portfolio.
-#
-# Hint: to convert a string to an integer, use int(s). To convert a string to a floating point, use float(s).
-#
-# Your program should print output such as the following:
-# Exercise 1.27
+
+import csv
 
 
 def portfolio_cost(filename):
 
@@ -1,3 +1,49 @@
 # report.py
 #
 # Exercise 2.4
+import csv
+
+portfolio = []
+
+
+# def read_portfolio(filename):
+#
+#     """ Computes the total cost (shares*price) of a portfolio file """
+#
+#     with open(filename, 'rt') as rows:
+#         header = next(rows)
+#         print(header)
+#         for row in rows:
+#             line = row.split(',')
+#             holding = (line[0], int(line[1]), float(line[2]))
+#             portfolio.append(holding)
+#         return portfolio
+#
+#
+# cost = read_portfolio('Data/portfolio.csv')
+# print(cost)
+
+# Now as a dictionary:
+def read_portfolio(filename):
+
+    """ Computes the total cost (shares*price) of a portfolio file """
+
+    with open(filename, 'rt') as file:
+        header = next(file)
+        total = 0
+        for line in file:
+            line2 = line.split(',')
+            total += (int(line2[1])) * (float(line2[2]))
+        return total
+
+
+cost = read_portfolio('Data/portfolio.csv')
+print(cost)
+
+
+
+
+
+
+
+