Join Csv files in the same directory

join_csvs.py

'''
Script for join CSV
author: @xtornaso5l2
'''

import os
files = os.listdir(os.curdir)
# ['.DS_Store', 'download (1).csv', 'download (2).csv', 'download.csv']
files.remove('.DS_Store') # Only for mac
# ['download (1).csv', 'download (2).csv']
with open('name_file.csv', 'w') as outfile:
    for file in files:
        with open(file) as infile:
            for line in infile:
                outfile.write(line)

join_two_files_csv_differents.py

''' Can join two diferents csv files  Author:@xtornasol512 '''
import csv

with open('results.csv', 'w') as outfile:
    with open('file_one.csv', 'rb') as f:
        # file has space to delimiter rows, actually is not a csv.
        spamreader = csv.reader(f, delimiter=' ', quotechar='|')
        for row in spamreader:
            # add format converting to a csv separated by tabs 
            line_tab = '\t'.join(row) + '\t\n'
            outfile.write(line_tab)


    with open('file_two.csv', 'rb') as file:
        # This file is already a tab csv so just add lines
        for line in file:
            outfile.write(line)