import csv
import random
from random import choice
#import unidecode #remove acentuacao
from unidecode import unidecode
icp = ['@gmail.com','@gmal.com','@gmaiu.com','@gmail.com.br','@gmil.com', '@outlook.com', '@hotmail.com', '@hotmaiu.com', '@homail.com', '@hotmil.com', '@hotmail.com.br']
ddd = [61,62,64,65,66,67,82,71,73,74,75,77,85,88,98,99,83,81,87,86,89,84,79,68,96,92,97,91,93,94,69,95,63,27,28,31,32,33,34,35,37,38,21,22,24,11,12,13,14,15,16,17,18,19,41,42,43,44,45,46,51,53,54,55,47,48,49]
with open('E:/xampp/htdocs/pmweb/data2dev/###Projetos/data/nomespessoas.csv','r', encoding="utf8") as csvinput:
with open('E:/xampp/htdocs/pmweb/data2dev/###Projetos/data/nomespessoas_output.csv', 'w', encoding="utf8") as csvoutput:
writer = csv.writer(csvoutput, lineterminator='\n')
reader = csv.reader(csvinput)
def remove(string):
return "".join(string.split())
def telddd():
return (choice(ddd))
def telef():
return random.randint(1000,9999)
def telefull():
return '(' + str(telddd()) + ')9' + str(telef()) + '-' + str(telef())
all = []
row = next(reader)
row.append('EMAIL')
row.append('TELEFONE')
all.append(row)
for row in reader:
#row.append(row[0])
sample_str = row[0]
pos_of_at = row[0].find(';')
first_chars = sample_str[pos_of_at+1:10]
first_chars = remove(first_chars)
first_chars = first_chars + random.choice(icp)
first_chars = first_chars.lower()
first_chars = unidecode(first_chars)
#num_telef = '(51)98765-4321'
num_telef = telefull()
row.append(first_chars)
row.append(num_telef)
all.append(row)
writer.writerows(all)