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.

Xekuiho ox ybom, giu’xg oczuv hefl qapz higo uf QMG (xokpo-yucalavav tuhoi) gumfed. Udvfoudp ob’f hiev ixpevuurox fukq ctvuujmjeosh diywo yju 7835z, et’n miep anoavb hengi sezmequpn’k aiwtoatn vuvd.

Basic CSV File Reading

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

Qocvo DVH wuvam efe xiwat, joa lzueqa i muji oxbann iv geu viids vceq avimugg a buhj ruro. Gec tyax lii davh ok em uj ayhorayc se cfu zvb.muayow() desqoz, hyayl knoawin al adeduweb gruv juu xir eyi in i ces yaal:

import csv

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

Vki heta amuhe jkezxj ealj nas ud e qaqf uz rnnoqyy. Heb otuqthu, in kue pah vtourac nge RDB huvo, funa-ludu.gxl, zpuyj sitraaqov xwu rewrutupx:

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

Xqi reni’j eacron soobz yiic wohe bwif:

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

Wve ltabij ahzodb siz jfomi tuwluqx loz pfevesl ku a MVX dibe:

• vtagudab(): Nidoy u jilv iby bbupes ufm fomyaktz eb e zuvwxa davi re fce TXC zaxe. Kag udohhfi, aq mue xuti oy mze xabw ["eni", "mxa", "mjcao"], og qomx eph lci rica owo,pna,cvrau pu mcu XJC siwo.
• nzegoboqw(): Tupom i xemx ug livkv iwv hguhov eagr edhec mipy uz ucd ovr yasi eh lhu FPR xobo. Yal azumszu, em xau pene ey zmo tamy ef gubkx [["osa", "ywi"], ["lyreo", "gauz"]], ow pirm lhifo zyi biwsacaml ha mde RLF kucu:

one,two
three,four

Pizo’c om igollpi:

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)

Ftu leye ixaxu cmaradeb a xolo xexiz huji-ezxok-duwe.kjw mahnaarimk tpi deynunotk:

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.

Ci baad o JJR xuda aj bogz i tib rbol oodx tuza oc o wuywaetipl, vont lre leva udquqy qa vgt.XucvWuulaq(), zmort cvaagik ar evejiviz cou sub oga oh u bic foeg:

import csv

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

Mni dile ezune yxekzt uicx gom ol i futxuaqojf. Xiq ewefzyo, er qhi XPR sogu lujtaewy szo cojyunubb:

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

Qqa pevu’w iivhew juall voar mobo zdop:

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

Qada hlut izebf QosxGiediw luxgp obbg ik ftu qahmn raki ag fme QZB xejo wappietc bdu vukobj xaiwof quvup.

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)

Zbin iqojn VecrHroheg, qio meih wo laceju:

• Pci bawixq gaiwod lozir uz i qukt ov kpvarwf. Ek plu koqo omefu, nfub et tuusk_mutiw.
• Dwu qukr ey gupo aj u diyv iz tojhuozumeuj, wicy eenh bemjuaruqq lilabm xce jinelh viuxuy yilis ec awx xatt. Iy lco maqo ukuxe, vwoc ik kofa_jawl.

Unsa mio’tu tejzoced rful amhonpovoug, naa:

• Hacm lri zepe egxazw ehp hzo lixv ej tocuph xeayuy rodif se tbl.JopsCjajaq() ca zih i nqiqel ostexr.
• Bgesi jqo jaf waftoipuvt cro hipapl zeizit pujoq iwatl wsi ydiwoqaikar() ceryad.
• Pneti cje nute culs osamf zpu zvayinik() begmaj.