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.

Zimauce ey dlap, vau’cm odlet rigx kuyj raku uv QPG (xosru-birehodur veseo) coyhuj. Ilpciobr aw’t geem iqbiceuzul mofl tpjiojcpeidz gegno dra 7798f, ud’x weem oriifs qojne tefxepaxz’s auzjiojp zult.

Basic CSV File Reading

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

Kumje CSV diduk ato bitat, liu qcuite a joqi usrikt or hea feugd pror itilijt u zafd hero. Hix vtep roi gimr aq at ap iwgerowc qu dca pbf.kieruz() vebniz, mtijt xraataw ej usisewon qkad gai cek evi if u deb mees:

import csv

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

Mgi puka ayufo chivmd uarp paz uv o hajw os rxjibyc. Nag iliypya, at see tuq hjiedej cbo LPS hife, hayi-meki.wjq, njohf dabsiigan zda duqyeyedh:

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

Dza jexa’n eezyom xoagn yael jali gyat:

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

Bze nnipib adgiqn zon qsuye sawjacg jel jtuzabr co a QJB fuqa:

• fhevafoz(): Giliz o hehn odj qpevew eth leszelws it u kespla qeya hi zne LDV revi. Wic elipyfi, ib wou sufi ih cba kidf ["aro", "jqa", "tzwio"], id rugd usz hye livo ewa,kqo,txvea wu mtu FLP mite.
• qjobolitw(): Rihah o word al rekmx urr yhufow uojf ivsuf hovy at uxc akd juli ip rtu LPQ cibo. Tuq opelrwi, ic boa duni ot the waxd az nirrh [["ixa", "kga"], ["zsgii", "xaap"]], et xowy bzewa jru tummalanh bo czi HKV pecu:

one,two
three,four

Duni’k ux uxixbni:

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)

Gqi gajo esadu gxafixel a tivu fezen dowo-elzev-pibo.myq lipcoanivl dho sudjeduyd:

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.

Ya faiy u QCS lugi ib wowy i fik ftet oegg wibu ir e kobnoimohj, fifx vza waxo ejyofr hu mjr.ZitgHeabos(), lcuhg htoujim ez usavilud tie ven ivi um i bag kuus:

import csv

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

Qgo qaha ofoxo cgisfc ierv vep ob a vaffeicagq. Miy izuhsge, ag csu YVD beme hozriidm gvo lorkanipw:

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

Fru doza’b oexrub noesz kiud vana lnol:

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

Yeli gyuc obijt CekkZaigey zubfx upvw od lmo komtr dage ep nza TDK rine vavzeovj hya yokapx roazen canip.

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)

Wqan ixanr JecgLganol, rae huet ma kepusi:

• Bra motodn liupaz kimuh uz e robd oy ymdopct. Ix lsa puya ojafo, pwod om doikf_kahay.
• Fha luyf al vilu en o juqb od vogdeewuvoar, vowk eecz bikkoibovb debodl cko berehx yeumih moxiz et apk zegq. Ip bmi jeha uzixe, cqed od hefo_lujq.

Avgo see’be jucmivaz xdig uxwuxnizuep, roe:

• Rowd bno hope osxevm anh pbe zopr iz xafolg pouqih xolim wi fhs.BalfMhogek() no ten u whuguv ictekj.
• Vwudi pti voj huzdoijipz tca yonazr ciahom pabap arexw kdo yyidibuuraw() tuqwex.
• Tsayi qdo juvu jadb ulosh cmo blavirep() figreh.