import csv
import numpy as np
import pandas as pd
def convertToInt(s):
try:
return int(s)
except:
return 0
def convertToFloat(s):
try:
return float(s)
except:
return 0.0
datalist=[]
with open('opendata106N0101.csv',encoding='utf-8')as file:
rows = csv.reader(file)
for row in rows:
if row[0] == '106' or row[0] == '統計年':
row[2] ==convertToInt(row[2])
row[3] ==convertToFloat(row[3])
row[4] ==convertToInt(row[4])
datalist.append(row)
title=datalist.pop(0)
title
datalist

import csv
import numpy as np
import pandas as pd
def convertToInt(s):
try:
return int(s)
except:
return 0
def convertToFloat(s):
try:
return float(s)
except:
return 0.0
datalist=[]
with open('opendata106N0101.csv',encoding='utf-8')as file:
rows = csv.reader(file)
for row in rows:
if row[0] == '106' or row[0] == '統計年':
row[2] ==convertToInt(row[2])
row[3] ==convertToFloat(row[3])
row[4] ==convertToInt(row[4])
datalist.append(row)
title=datalist.pop(0)

title
datalist