Advertisement
carlosagmtz05

python eliminate accents

Mar 5th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.54 KB | None | 0 0
  1. import csv
  2. import pyodbc
  3. conn = pyodbc.connect('DSN=CData Facebook Source Sys;User=X;Password=Y')
  4. crsr = conn.cursor()
  5.  
  6. crsr.execute("SELECT FromName, Message, FROM Wall WHERE Target = 'CNNee'")
  7. rows = crsr.fetchall()
  8. for row in rows:
  9.   print(row.FromName, row.Message)
  10.  
  11. # rows = crsr.execute()
  12. with open(r'C:\Users\user1\Desktop\CNNee.csv', 'w', newline='', encoding='utf-8') as csvfile:
  13.     writer = csv.writer(csvfile)
  14.     writer.writerow([x[0] for x in crsr.description])  # column headers
  15.     for row in rows:
  16.         writer.writerow(row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement