PrivacyRetrieval/static/software/1/2023-03-12 09:02:06.142486/SAP检测项目/roytuts-python/python-csv-read/csv-reader.py

#import csv

#with open('sample.csv', newline='') as csvfile:
#	samplereader = csv.reader(csvfile, delimiter=',', quotechar='|')
	
#	for row in samplereader:
#		print(', '.join(row))

#file = open('sample.csv')
#csv_file = csv.reader(file)   
#data = []

#for row in csv_file: 
	#data.append(row)

#file.close()

#print (data[1:])

#with open('sample.csv', newline='') as f:
#    reader = csv.reader(f)
#    for row in reader:
#        print(row)

#import csv, sys

#filename = 'sample.csv'
#with open(filename, newline='') as f:
#    reader = csv.reader(f)
#    try:
#        for row in reader:
#            print(row)
#    except csv.Error as e:
#        sys.exit('file {}, line {}: {}'.format(filename, reader.line_num, e))

#import csv

#with open('sample.csv', newline='', encoding='utf-8') as f:
#    reader = csv.reader(f)
#    for row in reader:
#        print(row)

#import csv

#with open('sample', newline='') as f:
#    reader = csv.reader(f, delimiter=',', quoting=csv.QUOTE_NONE)
#    for row in reader:
#        print(row)

#import csv

#with open('sample.csv', newline='') as csvfile:
#	reader = csv.DictReader(csvfile)
#	for row in reader:
#		print(row['policyID'], row['statecode'], row['county'])

from io import StringIO
import csv

string = """policyID,statecode,county,eq_site_limit,hu_site_limit,fl_site_limit,fr_site_limit,tiv_2011,tiv_2012,eq_site_deductible,hu_site_deductible,fl_site_deductible,fr_site_deductible,point_latitude,point_longitude,line,construction,point_granularity
119736,FL,CLAY COUNTY,498960,498960,498960,498960,498960,792148.9,0,9979.2,0,0,30.102261,-81.711777,Residential,Masonry,1
448094,FL,CLAY COUNTY,1322376.3,1322376.3,1322376.3,1322376.3,1322376.3,1438163.57,0,0,0,0,30.063936,-81.707664,Residential,Masonry,3
206893,FL,CLAY COUNTY,190724.4,190724.4,190724.4,190724.4,190724.4,192476.78,0,0,0,0,30.089579,-81.700455,Residential,Wood,1
333743,FL,CLAY COUNTY,0,79520.76,0,0,79520.76,86854.48,0,0,0,0,30.063236,-81.707703,Residential,Wood,3
172534,FL,CLAY COUNTY,0,254281.5,0,254281.5,254281.5,246144.49,0,0,0,0,30.060614,-81.702675,Residential,Wood,1
785275,FL,CLAY COUNTY,0,515035.62,0,0,515035.62,884419.17,0,0,0,0,30.063236,-81.707703,Residential,Masonry,3
995932,FL,CLAY COUNTY,0,19260000,0,0,19260000,20610000,0,0,0,0,30.102226,-81.713882,Commercial,Reinforced Concrete,1
223488,FL,CLAY COUNTY,328500,328500,328500,328500,328500,348374.25,0,16425,0,0,30.102217,-81.707146,Residential,Wood,1
433512,FL,CLAY COUNTY,315000,315000,315000,315000,315000,265821.57,0,15750,0,0,30.118774,-81.704613,Residential,Wood,1"""

f = StringIO(scsv)
reader = csv.reader(f, delimiter=',')
for row in reader:
    print(','.join(row))