DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone >

Merging Cells

Andrew Dunn user avatar by
Andrew Dunn
·
Sep. 11, 09 · · Code Snippet
Like (0)
Save
Tweet
4.75K Views

Join the DZone community and get the full member experience.

Join For Free
// This code reads a CSV file, takes two fields and merges them, then writes the merged field to a text file.


import csv
import os

os.chdir('Desktop')
cwd = os.getcwd()

reader = csv.reader(open('september crime data.csv', 'r'), dialect='excel')
open_file = open('streets.txt', 'w')

for row in reader:
    street_number = row[9]
    street_name = row[3]

    open_file.write(street_number + ' ' + street_name + '\n')
    

open_file.close()

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Suspicious Sortings in Unity, ASP.NET Core, and More
  • How To Use Cluster Mesh for Multi-Region Kubernetes Pod Communication
  • Why to Implement GitOps into Your Kubernetes CI/CD Pipelines
  • Testing Under the Hood Or Behind the Wheel

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo