format_csv.py

from pathlib import Path
import csv
import clean_string

dict = {'Luc Richard Mbah a Moute':'Luc Mbah a Moute',
		'Nene Hilario' : 'Nene'
}

dict_team = {'Was': 'Wsh'}

def format_sal(start_date, end_date):
	for j in range(start_date,end_date+1,1):
		for k in range(1,32,1):
			list = []
			current_path = Path('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\data\\%s.%s\\salaries%s.%s.csv' % (str(j),str(k),str(j),str(k)))
			if current_path.is_file():
				with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\data\\%s.%s\\salaries%s.%s.csv' % (str(j),str(k),str(j),str(k)), 'r') as csvf:
					csvreader = csv.reader(csvf, delimiter=',', lineterminator='\n')
					for row in csvreader:
						list.append(row)
				del list[0]
				copy_list = [_ for _ in list]
				new_list = []

				for i in range(len(copy_list)):
					semaphore = 0
					if copy_list[i][0].find('/') > 0:
						temp_list = []
						copyrow = copy_list[i]
						temp_list.append(copyrow[0][copyrow[0].find('/')+1:])
						for row in copyrow[1:]:
							temp_list.append(row)
						new_list.append(temp_list)
						copyrow.insert(0,copyrow[0][:copyrow[0].find('/')])
						del copyrow[1]
						if temp_list[0] == 'PG' or temp_list[0] == 'SG':
							semaphore = 1
							temp_list_2 = []
							temp_list_2.append('G')
							for row in temp_list[1:]:
								temp_list_2.append(row)
							new_list.append(temp_list_2)
						if temp_list[0] == 'SF' or temp_list[0] == 'PF':
							semaphore = 1
							temp_list_2 = []
							temp_list_2.append('F')
							for row in temp_list[1:]:
								temp_list_2.append(row)
							new_list.append(temp_list_2)
					if (copy_list[i][0] == 'PG' or copy_list[i][0] == 'SG') and semaphore == 0:
						temp_list = []
						temp_list.append('G')
						for row in copy_list[i][1:]:
							temp_list.append(row)
						new_list.append(temp_list)
					if (copy_list[i][0] == 'SF' or copy_list[i][0] == 'PF') and semaphore == 0:
						temp_list = []
						temp_list.append('F')
						for row in copy_list[i][1:]:
							temp_list.append(row)
						new_list.append(temp_list)
					temp_list = []
					temp_list.append('UTIL')
					for row in copy_list[i][1:]:
						temp_list.append(row)
					new_list.append(temp_list)

				with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\salaries\\salaries%s.%s.format.csv' % (str(j),str(k)), 'w') as csvf:
					csvwriter = csv.writer(csvf, delimiter=',', lineterminator='\n')
					for row in copy_list:
						row[1] = clean_string.cleanstr(row[1])
						if row[1] in dict:
							row[1] = dict.get(row[1])
						if row[5] in dict_team:
							row[5] = dict_team.get(row[5])
						csvwriter.writerow(row)
					for row in new_list:
						row[1] = clean_string.cleanstr(row[1])
						if row[1] in dict:
							row[1] = dict.get(row[1])
						if row[5] in dict_team:
							row[5] = dict_team.get(row[5])
						csvwriter.writerow(row)

def format_sal_single(date):
	list = []
	with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\data\\2017\\1.%s\\salaries1.%s.csv' % (str(date),str(date)), 'r') as csvf:
		csvreader = csv.reader(csvf, delimiter=',', lineterminator='\n')
		for row in csvreader:
			list.append(row)
	del list[0]
	copy_list = [_ for _ in list]
	new_list = []

	for i in range(len(copy_list)):
		semaphore1 = 0
		semaphore2 = 0
		if copy_list[i][0].find('/') > 0:
			temp_list = []
			copyrow = copy_list[i]
			temp_list.append(copyrow[0][copyrow[0].find('/')+1:])
			for row in copyrow[1:]:
				temp_list.append(row)
			new_list.append(temp_list)
			copyrow.insert(0,copyrow[0][:copyrow[0].find('/')])
			del copyrow[1]
			if temp_list[0] == 'PG' or temp_list[0] == 'SG':
				semaphore1 = 1
				temp_list_2 = []
				temp_list_2.append('G')
				for row in temp_list[1:]:
					temp_list_2.append(row)
				new_list.append(temp_list_2)
			if temp_list[0] == 'SF' or temp_list[0] == 'PF':
				semaphore2 = 1
				temp_list_2 = []
				temp_list_2.append('F')
				for row in temp_list[1:]:
					temp_list_2.append(row)
				new_list.append(temp_list_2)
		if (copy_list[i][0] == 'PG' or copy_list[i][0] == 'SG') and semaphore1 == 0:
			temp_list = []
			temp_list.append('G')
			for row in copy_list[i][1:]:
				temp_list.append(row)
			new_list.append(temp_list)
		if (copy_list[i][0] == 'SF' or copy_list[i][0] == 'PF') and semaphore2 == 0:
			temp_list = []
			temp_list.append('F')
			for row in copy_list[i][1:]:
				temp_list.append(row)
			new_list.append(temp_list)
		temp_list = []
		temp_list.append('UTIL')
		for row in copy_list[i][1:]:
			temp_list.append(row)
		new_list.append(temp_list)

	with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\salaries\\salaries1.%s.format.csv' % str(date), 'w') as csvf:
		csvwriter = csv.writer(csvf, delimiter=',', lineterminator='\n')
		for row in copy_list:
			row[1] = clean_string.cleanstr(row[1])
			if row[1] in dict:
				row[1] = dict.get(row[1])
			if row[5] in dict_team:
				row[5] = dict_team.get(row[5])
			csvwriter.writerow(row)
		for row in new_list:
			row[1] = clean_string.cleanstr(row[1])
			if row[1] in dict:
				row[1] = dict.get(row[1])
			if row[5] in dict_team:
				row[5] = dict_team.get(row[5])
			csvwriter.writerow(row)

def format_results(start_date, end_date):
	for i in range(start_date,end_date+1,1):
		for j in range(1,32,1):
			current_path = Path('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\data\\%s.%s\\results%s.%s.csv' % (str(i),str(j),str(i),str(j)))
			if current_path.is_file():
				list = []
				with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\data\\%s.%s\\results%s.%s.csv' % (str(i),str(j),str(i),str(j)), 'r', encoding='utf-8', errors="ignore") as csvf:
					csvreader = csv.reader(csvf, delimiter=',', lineterminator='\n')
					for row in csvreader:
						if row[7]:
							list.append(row)
				
				del list[0]
				for item in list:
					del item[:7]
					del item[1]

				with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\results\\results%s.%s.csv' % (str(i),str(j)), 'w') as csvf:
					csvwriter = csv.writer(csvf, delimiter=',', lineterminator='\n')
					for row in list:
						if row:
							row[0] = clean_string.cleanstr(row[0])
							if row[0] in dict:
								row[0] = dict.get(row[0])
							csvwriter.writerow(row)

def format_results_single(start_date):
	list = []
	with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\data\\2017\\1.%s\\results1.%s.csv' % (str(start_date),str(start_date)), 'r', encoding='utf-8', errors="ignore") as csvf:
		csvreader = csv.reader(csvf, delimiter=',', lineterminator='\n')
		for row in csvreader:
			if row[7]:
				list.append(row)

	del list[0]
	for item in list:
		del item[:7]
		del item[1]

	with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\results\\results1.%s.csv' % str(start_date), 'w') as csvf:
		csvwriter = csv.writer(csvf, delimiter=',', lineterminator='\n')
		for row in list:
			if row:
				row[0] = clean_string.cleanstr(row[0])
				if row[0] in dict:
					row[0] = dict.get(row[0])
				csvwriter.writerow(row)

def format_data(start_date, end_date):
	list = []
	for i in range(start_date,end_date+1,1):
		with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\data_predict%s.csv' % str(i), 'r') as csvf:
			csvreader = csv.reader(csvf, delimiter=',', lineterminator='\n')
			for row in csvreader:
				if row[7]:
					if float(row[7])>0:
						list.append(row)
	for row in list:
		if not row[7]:
			row[7] = float(0)
	with open('C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\data.csv', 'w') as csvf:
		csvwriter = csv.writer(csvf, delimiter=',', lineterminator='\n')
		for row in list:
			csvwriter.writerow(row)

def format_season():
	list = []
	filename = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\season.csv'
	with open(filename, 'r') as csvf:
		csvreader = csv.reader(csvf,delimiter=',',lineterminator='\n')
		for row in csvreader:
			temp_list = []
			temp_list.append(row[0])
			unpack = str(row[1])
			unpack = unpack.replace('{','')
			unpack = unpack.replace('}','')
			cnt = 0
			for i in range(unpack.count(',')+1):
				if i != unpack.count(','):
					temp_list.append(unpack[cnt:unpack.find(',',cnt)])
					cnt = unpack.find(',',cnt)+1
				else:
					temp_list.append(unpack[cnt:])
			list.append(temp_list)

	with open(filename,'w') as csvf:
		csvwriter = csv.writer(csvf,delimiter=',',lineterminator='\n')
		for row in list:
			csvwriter.writerow(row)

def get_results(num):
	list = []
	players = []
	player_results = []

	filename = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\lineup.csv'
	filename_results = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\results\\results1.%s.csv' % str(num)
	filename_new = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\lineup_results.csv'
	with open(filename, 'r') as csvf:
		csvreader = csv.reader(csvf,delimiter=',',lineterminator='\n')
		for row in csvreader:
			list.append(row)

	with open(filename_results, 'r') as csvf:
		csvreader = csv.reader(csvf,delimiter=',',lineterminator='\n')
		for row in csvreader:
			players.append(row[0])
			player_results.append(row[1])
	i = len(list)
	x = 0
	while x < i:
		if list[x][0] in players:
			loc = players.index(list[x][0])
			list[x].append(player_results[loc])
		if list[x][0] == 'estimated point is ':
			total = 0
			for j in range(2,10,1):
				total += float(list[x-j][8])
			phrase = "actual point total is ", total
			list.insert(x+1,phrase)
			i += 1
		x += 1
	with open(filename_new,'w') as csvf:
		csvwriter = csv.writer(csvf,delimiter=',',lineterminator='\n')
		for row in list:
			csvwriter.writerow(row)

def get_results_two(num):
	list = []
	players = []
	player_results = []

	filename = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\lineup_two.csv'
	filename_results = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\results\\results1.%s.csv' % str(num)
	filename_new = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\lineup_two_results.csv'
	with open(filename, 'r') as csvf:
		csvreader = csv.reader(csvf,delimiter=',',lineterminator='\n')
		for row in csvreader:
			list.append(row)

	with open(filename_results, 'r') as csvf:
		csvreader = csv.reader(csvf,delimiter=',',lineterminator='\n')
		for row in csvreader:
			players.append(row[0])
			player_results.append(row[1])
	i = len(list)
	x = 0
	while x < i:
		if list[x][0] in players:
			loc = players.index(list[x][0])
			list[x].append(player_results[loc])
		if list[x][0] == 'estimated point is ':
			total = 0
			for j in range(2,10,1):
				total += float(list[x-j][8])
			phrase = "actual point total is ", total
			list.insert(x+1,phrase)
			i += 1
		x += 1
	with open(filename_new,'w') as csvf:
		csvwriter = csv.writer(csvf,delimiter=',',lineterminator='\n')
		for row in list:
			csvwriter.writerow(row)

def format_template(num):
	list = []
	filename = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\template.csv'
	filename_results = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\template1.%s.csv' % str(num)

	with open(filename, 'r') as csvf:
		csvreader = csv.reader(csvf,delimiter=',',lineterminator='\n')
		for row in csvreader:
			list.append(row)
	del list[0]
	del list[1][:40]

	for i in range(len(list)):
		del list[i][:11]
		del list[i][2:]

	del list[:7]
	with open(filename_results, 'w') as csvf:
		csvwriter = csv.writer(csvf,delimiter=',',lineterminator='\n')
		for row in list:
			row[0] = clean_string.cleanstr(row[0])
			csvwriter.writerow(row)

def get_lineup(num):
	players = []
	nums = []
	teams = []
	temp_list = []
	list = []
	cnt = 0

	filename = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\template1.%s.csv' % str(num)
	filename_lineup = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\lineup.csv'
	filename_new = 'C:\\Users\\Nicholas\\Documents\\GitHub\\Fantasy\\template1.%snew.csv' % str(num)

	with open(filename, 'r') as csvf:
		csvreader = csv.reader(csvf,delimiter=',',lineterminator='\n')
		for row in csvreader:
			players.append(row[0])
			nums.append(row[1])

	with open(filename_lineup, 'r') as csvf:
		csvreader = csv.reader(csvf,delimiter=',',lineterminator='\n')
		for row in csvreader:
			if row[0] == '-' and row[1] == '-':
				teams.append(temp_list[:])
				del temp_list[:]
			else:
				temp_list.append(row)
			cnt += 1

	for i in range(len(teams)):
		if int(teams[i][8][1]) <= 50000:
			temp_list_2 = ['','','','','','','','']
			for j in range(8):
				if teams[i][j][3] == 'PG':
					try:
						loc = players.index(teams[i][j][0])
						temp_list_2[0] =   nums[loc]
					except:
						pass
				if teams[i][j][3] == 'SG':
					try:
						loc = players.index(teams[i][j][0])
						temp_list_2[1] =   nums[loc]
					except:
						pass
				if teams[i][j][3] == 'SF':
					try:
						loc = players.index(teams[i][j][0])
						temp_list_2[2] =   nums[loc]
					except:
						pass
				if teams[i][j][3] == 'PF':
					try:
						loc = players.index(teams[i][j][0])
						temp_list_2[3] =   nums[loc]
					except:
						pass
				if teams[i][j][3] == 'C':
					try:
						loc = players.index(teams[i][j][0])
						temp_list_2[4] =   nums[loc]
					except:
						pass
				if teams[i][j][3] == 'G':
					try:
						loc = players.index(teams[i][j][0])
						temp_list_2[5] =   nums[loc]
					except:
						print(teams[i][j][0])
						pass
				if teams[i][j][3] == 'F':
					try:
						loc = players.index(teams[i][j][0])
						temp_list_2[6] =   nums[loc]
					except:
						pass
				if teams[i][j][3] == 'UTIL':
					try:
						loc = players.index(teams[i][j][0])
						temp_list_2[7] =   nums[loc]
					except:
						pass
			list.append(temp_list_2[:])
	
	with open(filename_new, 'w') as csvf:
		csvwriter = csv.writer(csvf,delimiter=',',lineterminator='\n')
		for row in list:
			csvwriter.writerow(row)