[EMAIL PROTECTED] wrote:
hello,
i have the follwoing csv file:
"Berat","Berat","Kuçovë","Skrapar"
"Dibër","Bulqizë","Dibër","Mat"
"Durrës","Durrës","Krujë"
"Elbasan","Elbasan","Gramsh","Librazhd","Peqin"
"Fier","Fier","Lushnjë","Mallakastër"
"Gjirokastër","Gjirokastër","Përmet","Tepelenë"
"Korçë","Devoll","Kolonjë","Korçë","Pogradec"
"Kukës","Has","Kukës","Tropojë"
"Lezhë","Kurbin","Lezhë","Mirditë"
"Shkodër","Malësi e Madhe","Pukë","Shkodër"
"Tirana","Kavajë","Tirana"
"Vlorë","Delvinë","Sarandë","Vlorë"
where thee first column contains the regions and the subsequent the
districts.
what is the best way to return a file like:
"Berat","Kuçovë"
"Berat","Skrapar"
"Dibër","Bulqizë"
"Dibër","Dibër"
"Dibër","Mat"
etc...
and to write it out as a new file.
There is a csv module, but for something this simple the following will
suffice:
input = open(path-to-the-input-file, 'r')
output = open(path-to-the-output-file, 'w')
for line in input:
line = line.split(",") # ["Berat", "Berat", "Kuçovë", "Skrapar"]
region = line [0]
for district in line[1:]:
output.write(region + "," + district + "\n")
input.close()
output.close()
--
Bob Gailer
Chapel Hill NC
919-636-4239
When we take the time to be aware of our feelings and
needs we have more satisfying interatctions with others.
Nonviolent Communication provides tools for this awareness.
As a coach and trainer I can assist you in learning this process.
What is YOUR biggest relationship challenge?
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
