Ing Python, sampeyan bisa kanthi gampang maca lan nulis file csv nggunakake modul csv standar.
Contone, umpamane sampeyan duwe csv ing ngisor iki, sample.csv.
11,12,13,14
21,22,23,24
31,32,33,34
Iki bisa diwaca kaya ing ngisor iki.
import csv
with open('data/src/sample.csv', 'r') as f:
reader = csv.reader(f)
for row in reader:
print(row)
# ['11', '12', '13', '14']
# ['21', '22', '23', '24']
# ['31', '32', '33', '34']
Sing kudu digatekake ing kene yaiku nalika ana spasi sawise koma. Biasane, ora ana spasi sing ora perlu sawise koma, nanging kadhangkala aku ndeleng file kanthi spasi.
Ing kasus kaya mengkono, kanthi gawan, spasi putih ora diabaikan lan file kasebut diwaca apa wae.
11, 12, 13, 14
21, 22, 23, 24
31, 32, 33, 34
Ing tembung liya, yen sampeyan maca file ing ndhuwur kanthi koma sing diikuti spasi, output bakal kaya ing ngisor iki
with open('data/src/sample_space.csv', 'r') as f:
reader = csv.reader(f)
for row in reader:
print(row)
# ['11', ' 12', ' 13', ' 14']
# ['21', ' 22', ' 23', ' 24']
# ['31', ' 32', ' 33', ' 34']
Yen sampeyan nemtokake ing ngisor iki ing csv.reader, spasi sawise koma bakal dilewati.skipinitialspace=True
with open('data/src/sample_space.csv', 'r') as f:
reader = csv.reader(f, skipinitialspace=True)
for row in reader:
print(row)
# ['11', '12', '13', '14']
# ['21', '22', '23', '24']
# ['31', '32', '33', '34']
Ing conto prasaja kaya ing ndhuwur, sampeyan bisa nggunakake strip () kanggo mbusak spasi putih. Masalahe yaiku nalika diubengi tandha petik ganda kaya ing ngisor iki.
"one,one", "two,two", "three,three"
Bagean sing diubengi dening tandha petik pindho kudu dianggep minangka unsur siji, nanging yen skipinitialspace = Palsu (standar), bakal katon kaya ing ngisor iki.
with open('data/src/sample_double_quotation.csv', 'r') as f:
reader = csv.reader(f)
for row in reader:
print(row)
# ['one,one', ' "two', 'two"', ' "three', 'three"']
Iki bisa ditindakake kanthi nyetel skipinitialspace=True.
with open('data/src/sample_double_quotation.csv', 'r') as f:
reader = csv.reader(f, skipinitialspace=True)
for row in reader:
print(row)
# ['one,one', 'two,two', 'three,three']
Padha bener nalika maca file csv karo read_csv () ing panda. Yen file csv duwe spasi sawise koma, sampeyan bisa nindakake ing ngisor iki.read_csv(skipinitialspace=True)
