Question

Description Download 'hw6_numpy_wine.csv' as the source file, each row in the data file is some metrics about one type of wine. See first row for headers that's the names of the metrixes. Requirements: 1. Write a function called 'read_from_file', that will use a numpy method to read in 2D data from the csv file. a. return the 2D ndarray data type to caller in 'main' 2. Write a function called 'get_combined_acidity'. This function will calculate the 'combined_acid' level, based on 3 columns: 'fixed acidity', 'volatile acidity' and 'citric acid'. Basically, it's a metric that will be the sum of values of those three columns. Say if a type of wine has 3, 4, 5 in the corresponding 3 columns, then the combined acidity for this wine will be 12. a. Return a 1D numpy ndarray of combined acidity, of all input wine types. b. hint: check the first few values of combined acidity to see if they make sense

Answer 1

Code:

# importing the numpy module
import numpy as np

# read_from_from function that reads a csv file and returns an 2D nd-array
def read_from_file(path):
  
data = np.genfromtxt(path, delimiter=',',skip_header=1)

# returning the 2D nd-array
return data

# Function call
arr = read_from_file("hw6_numpy_wine.csv")

# Displaying the result after function call
print("wine data: \n",arr)

# get_combined_acidity function that returns the combined acid level af all input wine types
def get_combined_acidity(arr):

# Adding the fixed acidity, volatile acidity and citric acid columns
combined = arr[:,0]+arr[:,1]+arr[:,2]

# returning the resultant 1D array
return combined

combined_acid = get_combined_acidity(arr)
print("Combined acidity: \n",combined_acid)

Indentation:

# importing the numpy module import numpy as np # read_from_from function that reads a csv file and returns an 2D nd-array def read_from_file(path) : data = np.genfromtxt (path, delimiter=', ', skip_header=1) # returning the 2D nd-array return data # Function call arr = read_from_file("hw6_numpy_wine.csv") # Displaying the result after function call print("wine data: \n", arr) # get_combined_acidity function that returns the combined acid level af all input wine types def get_combined_acidity (arr): # Adding the fixed acidity, volatile acidity and citric acid columns combined = arr[:,0] +arr[:,1] +arr[:,2] # returning the resultant in array return combined combined_acid = get_combined_acidity (arr) print ("Combined acidity: \n", combined_acid)

Sample Run:

wine data: [[ 7.4 0.7 [ 7.8 0.88 [ 7.8 0.76 0. 0. 0.04 ... ... ... 0.56 0.68 0.65 9.4 9.8 9.8 5. 5. 5. ] ] ] [ 6.3 0.51 0.13 ... 0.75 11. 6. [ 5.9 0.645 0.12 ... 0.71 10.2 5. [ 6. 0.31 0.47 ... 0.66 11. 6. Combined acidity: [8.1 8.68 8.6 ... 6.94 6.665 6.78 ] ] ] ]]