import os
import csv
import re

files=os.listdir("testdir")
regex=re.compile(r"^([^.]*).*")

def normalize_text(s):
  return s[0:s.find('.')]

with open('new-genes.tsv','w') as fout:
  writer = csv.writer(fout, delimiter='\t')
  writer.writerow(['head0', 'head3', 'tissue_type'])
  # writer.writerow([text.encode('utf-8'), excerpt.encode('utf-8')])

  for filename in files:
    with open("testdir/" + filename, 'r') as csvfile:
      reader = csv.DictReader(csvfile) # jenn: '\t'
      tissue_type = normalize_text(filename)
      print(tissue_type)
      for row in reader:
        writer.writerow([row['head0'], row['head3'], tissue_type])