import csv

dataset_1=[]
dataset_2=[]

with open('BRIGHT_STARS.csv','r')as f:
    csvreader = csv.reader(f)
    for row in csvreader:
        dataset_1.append(row)

with open('DRAFT_STARS.csv','r')as f:
    csvreader = csv.reader(f)
    for row in csvreader:
        dataset_2.append(row)

headers_1 = dataset_1[0]
planet_data_1 = dataset_1[1:]

headers_2 = dataset_2[0]
planet_data_2 = dataset_2[1:]

headers = headers_1+headers_2
planet_data = []
for index in planet_data_1:
    planet_data.append(index)

for index1 in planet_data_2:
    planet_data.append(index1)


with open('final.csv','a+')as f:
    csvwriter = csv.writer(f)
    csvwriter.writerow(headers)
    csvwriter.writerows(planet_data)