# https://www.globalsino.com/ICs/page4853.html
# Use specific columns

import numpy as np
import matplotlib.pyplot as plt
import pandas as pd


MyFileName = ('C:\GlobalSino\ICs\ExampleFiledUsedINtestingPython\CasePrediction6.csv')
names = ['Animal', 'Protein', 'Fat', 'Sale'] # names
dataset = pd.read_csv(open(MyFileName, 'rb'), names=names)

dataset = dataset.drop('Animal', axis=1)
print(dataset)

# Here X is Protein and Fat
# Drop the Sale column to extract the X variable.
print('\nExtract Protein and Fat')
X = dataset.drop('Sale', axis=1)
print(X)

# Target variable is Sale, namely Y
# Extract Sale
print('\nExtract Sale')
Y = dataset['Sale']
print(Y)