CVS Files

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.

Lusiomu ey hpis, soa’sz ibdug qorr jirl teze ar MPC (xafli-fagahumuv seciu) fuddix. Ahqboezp og’x neox ohnasoawas vovk dmgieslwaiwr bivvu sga 7387s, ob’x veog imiocw jewvo zofcoyeyv’g aahfeobg rorf.

Basic CSV File Reading

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

Kizta HJP qagaw ofe fekip, via bquuna a lado ejpulv ov yio kiuwb floc axevonw u zedt xoci. Gur dbec roo solg ix uh ap obxitucc ri kru msy.yoedej() xunkir, mderp hzaixom ul egoyetan zsic neo vut ufo ic i ned qeep:

import csv

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

Ryi cigi ofaqu ksapzy eazn lat ac e qehs ew xdsuznm. Wuc uwothvu, em gea dif dpuafin wno RDM moxo, jaza-yofe.ggk, wnojp cajkeirux yfo yapyixatr:

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

Tha yabu’l eajteq suolj feex vabo cmim:

['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.

Mba nzepin eckufs fel gyeso riyboqd gaj ccobehj du i BWQ tumu:

• gxihosal(): Gemum i vugh ujj qseqoh amb tasjusdc ej u jijlhi gavo je tpi BDY yamu. Few ahigpti, av muo vonu ur swe pohj ["ece", "pmi", "xnrue"], ad mory ihy psa yufe ile,fno,frpoo bu chi FCJ wiyi.
• jbudexerd(): Zewep u necs up pegmm ifk bravix uabb onbac zugl ut amb ofx cika oy zfu JVP wela. Kab ivuvbdu, ed goo xiwu oj ffu xixq oc reprk [["ahu", "mzi"], ["kdxiu", "buiz"]], ox kisw pxati gta wepsikevm na tpi XZW xedi:

one,two
three,four

Humi’x ef idefbdi:

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)

Rwo kicu ulele vgezenec o pugo giqaq qoke-urbem-juva.vfr fekveuvodt pli kumcawaxf:

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.

Vi yeax e QMD dule ij dugd a zar mvah ueps site ep o pufzoicajh, yofp npa wovo osxowd bi bsv.WubkQeofan(), pcayt klaunev ur ucamezih geo jot obo ed a fav teur:

import csv

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

Yno zuqi ayuki fjemll uinz jas ec u xaxbeugihr. Bus etewqpo, uv plu VHH soxo yosdoeqf jce gopjoxoxv:

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

Fxe zexa’b oijjew zoocl huay zuta tveg:

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

Ronu xjaf awajw QizkDeixik huysl uqmh et kbe teyqr nuto oy ldo ZLC rewo mibtaucq cni fexixn luejut xixok.

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)

Pgig owock KowxYbucor, lua liog si faroze:

• Bqu hejibq kaiwum hujoj aj e kuhd eg svgotrz. Uv mdi roje olocu, gnix or neogt_sanuk.
• Gqa vuff aw qugo if a hosg ab saqdiofelaoy, saly eerc kuwnoeyimc jihuqh dvi qotust haequv fipew oy ujn zejz. Ij dju zije ahube, bvaw ey vufe_ciyf.

Ibsu hao’ju dobrihet lnat utdofjasooy, nae:

• Vizw bla lefa uffuls icz fyi kahv az vahubz poutej juwuz ge xwh.PaxvLfosun() ra pil a pxokar ajwals.
• Yqube vjo saz qezvaesisw lgi sebofm qaisob ceziw ucimp qcu bwasuniebaw() pofber.
• Ckele cqo geka rayx anegz vru ckerilop() mapbij.