Skip to content

練習中老師可以把無數值的部分改換成0或0.0,但我都不行耶 #16

@TristaChu

Description

@TristaChu

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
註解 2021-01-22 203447

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions