Skip to main content
edited tags
Link
200_success
  • 145.7k
  • 22
  • 191
  • 481
Tweeted twitter.com/StackCodeReview/status/1568026477551050755
Became Hot Network Question
fix typo
Source Link

I want to transform this dict to CSV:

{
  "California": ["San Fransisco", "Los Angels"Angeles","Oakland"],
  "Texas": ["Dallas", "Houston", "Austin"],
  "Florida": ["Miami", "Tampa"],
  ...
}

I want the following output:

California,San Fransisco
California,Los Angeles
California,Oakland
Texas,Dallas
Texas,Houston
Texas,Austin
Florida,Miami
Florida,Tampa

I wrote this code. This works well, but I wonder if there is a more pythonic way to do the same.

import csv

d = {
    "California": ["San Fransisco", "Los Angels"Angeles","Oakland"],
    "Texas": ["Dallas", "Houston", "Austin"],
    "Florida": ["Miami", "Tampa"]
}

with open("./out.csv", "w") as f:
  header = ["state", "city"]
  writer = csv.writer(f)
  writer.writerow(header)
  for i in d.keys():
    for j in d[i]:
      writer.writerow([i,j])

I want to transform this dict to CSV:

{
  "California": ["San Fransisco", "Los Angels","Oakland"],
  "Texas": ["Dallas", "Houston", "Austin"],
  "Florida": ["Miami", "Tampa"],
  ...
}

I want the following output:

California,San Fransisco
California,Los Angeles
California,Oakland
Texas,Dallas
Texas,Houston
Texas,Austin
Florida,Miami
Florida,Tampa

I wrote this code. This works well, but I wonder if there is a more pythonic way to do the same.

import csv

d = {
    "California": ["San Fransisco", "Los Angels","Oakland"],
    "Texas": ["Dallas", "Houston", "Austin"],
    "Florida": ["Miami", "Tampa"]
}

with open("./out.csv", "w") as f:
  header = ["state", "city"]
  writer = csv.writer(f)
  writer.writerow(header)
  for i in d.keys():
    for j in d[i]:
      writer.writerow([i,j])

I want to transform this dict to CSV:

{
  "California": ["San Fransisco", "Los Angeles","Oakland"],
  "Texas": ["Dallas", "Houston", "Austin"],
  "Florida": ["Miami", "Tampa"],
  ...
}

I want the following output:

California,San Fransisco
California,Los Angeles
California,Oakland
Texas,Dallas
Texas,Houston
Texas,Austin
Florida,Miami
Florida,Tampa

I wrote this code. This works well, but I wonder if there is a more pythonic way to do the same.

import csv

d = {
    "California": ["San Fransisco", "Los Angeles","Oakland"],
    "Texas": ["Dallas", "Houston", "Austin"],
    "Florida": ["Miami", "Tampa"]
}

with open("./out.csv", "w") as f:
  header = ["state", "city"]
  writer = csv.writer(f)
  writer.writerow(header)
  for i in d.keys():
    for j in d[i]:
      writer.writerow([i,j])
Code fence
Source Link
Toby Speight
  • 88.7k
  • 14
  • 104
  • 327

Is there a pythonic-way to output Transform dict dataof lists to csv files?CSV

I want to output data intransform this dict to CSV file in the following format,:

{
  "California": ["San Fransisco", "Los Angels","Oakland"],
  "Texas": ["Dallas", "Houston", "Austin"],
  "Florida": ["Miami", "Tampa"],
  ...
}
California,San Fransisco
California,Los Angeles
California,Oakland
Texas,Dallas
Texas,Houston
Texas,Austin
Florida,Miami
Florida,Tampa

I want the following output:

California,San Fransisco
California,Los Angeles
California,Oakland
Texas,Dallas
Texas,Houston
Texas,Austin
Florida,Miami
Florida,Tampa

so I wrote this code. This works well, but I wonder if there is a more pythonic way to do the same.

import csv

d = {
    "California": ["San Fransisco", "Los Angels","Oakland"],
    "Texas": ["Dallas", "Houston", "Austin"],
    "Florida": ["Miami", "Tampa"]
}

with open("./out.csv", "w") as f:
  header = ["state", "city"]
  writer = csv.writer(f)
  writer.writerow(header)
  for i in d.keys():
    for j in d[i]:
      writer.writerow([i,j])
```

Is there a pythonic-way to output dict data to csv files?

I want to output data in dict to CSV file in the following format,

{
  "California": ["San Fransisco", "Los Angels","Oakland"],
  "Texas": ["Dallas", "Houston", "Austin"],
  "Florida": ["Miami", "Tampa"],
  ...
}
California,San Fransisco
California,Los Angeles
California,Oakland
Texas,Dallas
Texas,Houston
Texas,Austin
Florida,Miami
Florida,Tampa

so I wrote this code. This works well, but I wonder if there is a more pythonic way to do the same.

import csv

d = {
    "California": ["San Fransisco", "Los Angels","Oakland"],
    "Texas": ["Dallas", "Houston", "Austin"],
    "Florida": ["Miami", "Tampa"]
}

with open("./out.csv", "w") as f:
  header = ["state", "city"]
  writer = csv.writer(f)
  writer.writerow(header)
  for i in d.keys():
    for j in d[i]:
      writer.writerow([i,j])
```

Transform dict of lists to CSV

I want to transform this dict to CSV:

{
  "California": ["San Fransisco", "Los Angels","Oakland"],
  "Texas": ["Dallas", "Houston", "Austin"],
  "Florida": ["Miami", "Tampa"],
  ...
}

I want the following output:

California,San Fransisco
California,Los Angeles
California,Oakland
Texas,Dallas
Texas,Houston
Texas,Austin
Florida,Miami
Florida,Tampa

I wrote this code. This works well, but I wonder if there is a more pythonic way to do the same.

import csv

d = {
    "California": ["San Fransisco", "Los Angels","Oakland"],
    "Texas": ["Dallas", "Houston", "Austin"],
    "Florida": ["Miami", "Tampa"]
}

with open("./out.csv", "w") as f:
  header = ["state", "city"]
  writer = csv.writer(f)
  writer.writerow(header)
  for i in d.keys():
    for j in d[i]:
      writer.writerow([i,j])
Source Link
Loading