Question

I need help modifying this python code:

a) I need to take 2 attributes of the data as int - (columns (3 & 5) of my data)

b) I need to take 2 more attributes as floats -(columns 4&6 of my data)

c) I need to take 1 attribute as string (column 16 of my data)

How would I modify this code

#
# Initial version - "standard programming"
#
# Define a list for the data. The data structure will be a list of lists.
data = []
# open the file
fname = "..\data\Online_shoppers.csv"
f = open(fname, "r")
# ignore the first 1 line(header)
for i in range(2):
line = f.readline()
# loop until we run out of lines
while (line):
# strip the newline and tokenize (split on commas, in this case)
tokens = line.rstrip().split(',')
# append this record to the dataset
data.append(tokens)
# read the next line
line = f.readline()
# close the file
f.close()
# show the data
show(data)

Answer 1

#I am assuming you need the whole column, but the specified columns in the data type provided.If this is not the case, please clarify in comments

#
# Initial version - "standard programming"
#
# Define a list for the data. The data structure will be a list of lists.
data = []
# open the file
fname = "..\data\Online_shoppers.csv"
f = open(fname, "r")
# ignore the first 1 line(header)
for i in range(2):
line = f.readline()
# loop until we run out of lines
while (line):
# strip the newline and tokenize (split on commas, in this case)
tokens = line.rstrip().split(',')
tokens[2]=int(tokens[2])#converting to int
tokens[4]=int(tokens[4])#converting to int
tokens[3]=float(tokens[3])#converting to float
tokens[5]=float(tokens[5])#converting to float
  
# append this record to the dataset
data.append(tokens)
# read the next line
line = f.readline()
# close the file
f.close()
# show the data
show(data)