# https://www.globalsino.com/ICs/page4853.html
# Print cell values

import csv
import random

def LoadDataset(FileName, split, TrainingSet=[], testSet=[]):
    with open(FileName, 'r') as Mycsvfile:         
         csvreader = csv.reader(Mycsvfile)
         # csvreader = csv.reader(Mycsvfile, delimiter=' ', quotechar='|')
         next(csvreader)
         dataset = list(csvreader)
         for x in range(len(dataset)-1):
             # range
             for y in range(4):
                 dataset[x][y] = int(dataset[x][y])
                 # print all values cell by cell in order of row and column in the csv file
                 print(dataset[x][y])
             if random.random()<split:
                 trainingSet.append(dataset[x])
             else:
                 testSet.append(dataset[x])

trainingSet=[]
testSet=[]

# "split" = total*0.66-1 (csv file has 42 rows of data)
LoadDataset('C:\GlobalSino\images\CasePrediction2.csv', 0.80,  trainingSet, testSet)
print('Train:' + repr(len(trainingSet)))
print('Test:' + repr(len(testSet)))