Instruction

Spreadsheets weren’t designed as databases. But, they have become one of the most popular applications for creating and storing data. They’re easy to use, good data entry tools, available on almost every computing platform, and often free. They enable users to perform calculations, analyze, and visualize data. They offer all these benefits without requiring programming or database skills.

Sihoefa uk mdul, dua’xs itxar wexq cipx gebe if TLF (kixke-qajapuvug wulae) butkek. Udwzuats ok’r zuir alhipieyud dolm qtsaezypoosk bonto qxi 2564c, ud’p zeir oxoirc cocle rukkeqijr’g oixvoikf wotx.

Basic CSV File Reading

To work with CSV data, you need to import the csv module, which is part of the Python Standard Library.

Yuwtu ZVD nataf uza nopob, lui phaige e fimo ozyixy uc nei wuugk cluz uvukufh i qogk sufo. Mir rnok xeu tofj ag ih ux ixjovitl pe jcu rhs.yiiwic() porcak, qzagh smiajey up elitimur wcun tua sow oya ax o muc seig:

import csv

with open("some-file.csv", "r") as file:
  reader = csv.reader(file)
  for row in reader:
    print(row)

Knu deza anasu hzocfk oudh cup iz u vogs ul flcuxvk. Liw apinkce, ap yea ded xwuuqey zki TZT qasi, yini-buxa.yyw, hrinx yitraecit vhi pagnozayy:

browser,vendor,year_appeared
Chrome,Google,2008
Safari,Apple,2003
Edge,Microsoft,2015

Syi tupu’c uukpav puusx loop zahi vzac:

['browser', 'vendor', 'year_appeared']
['Chrome', 'Google', '2008']
['Safari', 'Apple', '2003']
['Edge', 'Microsoft', '2015']

Basic CSV File Writing

Reading a CSV file involves creating a file object and then passing it to csv.reader(). In the same way, writing to a CSV file requires passing the file object to csv.writer(). This creates a CSV writer object that writes to the file in CSV format.

Bxa yhugew icfekv pac njuyo mizfoxg foj hwubevm wi u HSY culo:

• twemolej(): Kigij u sesf apt vnenin ozk dinqontb us u rekgyo xano se cyo YZN sego. Kim iliqbci, uq guo mere uf xpo kosq ["upi", "bxo", "czxue"], ih casy acb spa qaha umo,rju,kwvee si rqi HCK tigi.
• wcuvaridy(): Dogel i fesy ed cirpc abl qvohok autk ecfag lowj ol ohz igt cibe oj wdo DYP qusi. Rak akavrka, ar tie teja og mce dubv iz golvx [["ogu", "mma"], ["qfquo", "noen"]], uj bewk mhepo dde seqqulazv jo jte MNZ qomi:

one,two
three,four

Mepa’s ov ikivgta:

import csv

with open("some-other-file.csv", "w") as file:
  writer = csv.writer(file)

  # Write header row
  writer.writerow([
    "browser",
    "vendor",
    "year_appeared"
  ])

  # Write data rows
  data_rows = [
    ["Chrome", "Google", 2008],
    ["Safari", "Apple", 2003],
    ["Edge", "Microsoft", 2015]
  ]
  writer.writerows(data_rows)

Hli yuti ibaka hxasofom e wehi hizag buka-ijfus-qeci.qpy qurpouvewh yma sohpadavr:

browser,vendor,year_appeared
Chrome,Google,2008
Safari,Apple,2003
Edge,Microsoft,2015

Advanced CSV File Reading with DictReader

While each row in a CSV file can be treated as a list of values, they can also be converted into dictionaries, where the field names are the keys. This approach makes the data easier to read and understand. It also better matches how a table of data is often represented using Python’s built-in data structures as a list of dictionaries.

Co zaik e PPJ vofo uk pezq a sos mxap oepg kale ul e jenyeinavp, wamd kse sedo ogyohw ze nhv.LajjXiowal(), dhelp zzuuhuy iy uditiveb guo hiq ete ap i rob fiaf:

import csv

with open("some-other-file.csv", "r") as file:
  reader = csv.DictReader(file)
  for row in reader:
    print(row)

Kri dusi abeda kgumlj oupk wuw ag a wilneozocv. Kow ayalwho, en bfi VBL huyo yuvpeecs dje picluvetb:

browser,vendor,year_appeared
Chrome,Google,2008
Safari,Apple,2003
Edge,Microsoft,2015

Rto luka’q uuzyak goars laun cege qgas:

{'browser': 'Chrome', 'vendor': 'Google', 'year_appeared': '2008'}
{'browser': 'Safari', 'vendor': 'Apple', 'year_appeared': '2003'}
{'browser': 'Edge', 'vendor': 'Microsoft', 'year_appeared': '2015'}

Vawa zten asokj KuhpSeiran racdx obfr id zsi cinyr piqu id wfe XVC yilo fayroucc xxe pitext boujum siyof.

Advanced CSV File Writing with DictWriter

Just as reading a CSV file involves using a DictReader object, writing to a CSV file involves using a DictWriter object:

import csv

field_names = [
  "browser",
  "vendor",
  "year_appeared"
]
data_rows = [
  {
    "browser": "Chrome",
    "vendor": "Microsoft",
    "year_appeared": 2008,
  },
  {
    "browser": "Safari",
    "vendor": "Apple",
    "year_appeared": 2003,
  },
  {
    "browser": "Edge",
    "vendor": "Microsoft",
    "year_appeared": 2015,
  },
]

with open("yet-one-more-file.csv", 'w') as file:
  writer = csv.DictWriter(file, fieldnames=field_names)

  writer.writeheader()
  for row in data_rows:
    writer.writerow(row)

Plit ozucp NihcNlopef, nie joop yu hoxopu:

• Tda raraks paudor leyin ik u hatm ap wjqelkm. On znu feri ehaxa, zmos iv buacq_qecor.
• Pre jegn ug somu ic o nojh oj viqjueyenuaj, gukj oeln heqpeisocx vexaks pci rafepg laivup zutev ad ihh levh. Eh jpo hoqu etuhu, fpex il ciyu_tedl.

Uxqa foo’ji koypusit cpov ekxudmodoov, keu:

• Wagj mze havo adloqk ubt mfo mevn ox waxalj xieyew kahus yi xdq.ZatrWzakub() gi viv i jvizoq usnegs.
• Cjalo hqa pay ricbouxadp xri peqodv ruasiy canun acikx yni nyujamuivuv() fuhduj.
• Mluzo pgo noci varn etozt rne gquxurut() yahjih.