def DATA_Merger(infilename1, infilename2):
filename_list1 = read_file_name(infilename1)
infile1 = filename_list1[2]
filename_list2 = read_file_name(infilename2)
infile2 = filename_list2[2]
DATE_ROW = MakeList_column(infile1)
DATA_ROW = MakeList_column(infile2)
for i in range(len(DATA_ROW)):
DATE_ROW.append(DATA_ROW[i])
NEWNAME = infile1.replace(".txt", "_MERGE_" + filename_list2[0])
FN = NEWNAME + ".txt"
Of = open(FN, "w+")
for j in range(len(DATE_ROW[0])):
for i in range(len(DATE_ROW)):
Of.write("%s" % DATE_ROW[i][j])
if (i != len(DATE_ROW) - 1):
Of.write(" ")
else:
Of.write("\n")
# Of.write("%s " %DATE_ROW[0][j])
# Of.write("%s\n" %DATE_ROW[1][j])
Of.close()
return FN
def Merge(filename1, filename2):
if(filename1[0]=="/"):
filename1 = filename1
elif((filename1[0]=="C")&(filename1[1]==":")):
filename1 = filename1
else:
filename1 = os.getcwd() + "/" + filename1 # get the path included filename
loca1=len(filename1)
for i in range (1,len(filename1)+1): # find the "/" location
if(filename1[-i] == "/"):
loca1 = i-1
break
FILENAME1 = filename1.replace(filename1[:-loca1],"") # this is the shorten filename
filename1_No_Txt = FILENAME1.replace(".txt","")
infile1 = filename1
if(filename2[0]=="/"):
filename2 = filename2
elif((filename2[0]=="C")&(filename2[1]==":")):
filename2 = filename2
else:
filename2 = os.getcwd() + "/" + filename2 # get the path included filename
loca2=len(filename2)
for i in range (1,len(filename2)+1): # find the "/" location
if(filename2[-i] == "/"):
loca2 = i-1
break
FILENAME2 = filename2.replace(filename2[:-loca2],"") # this is the shorten filename
filename2_No_Txt = FILENAME2.replace(".txt","")
infile2 = filename2
DATE_ROW = MakeList_column(infile1)
DATA_ROW = MakeList_column(infile2)
# DATE_ROW.append(DATA_ROW[0])
for i in range(len(DATA_ROW)):
DATE_ROW.append(DATA_ROW[i])
# print(DATE_ROW)
# print(len(DATE_ROW[0]))
# print(len(DATE_ROW[1]))
NEWNAME = infile1.replace(".txt","_MERGE_"+filename2_No_Txt)
FN = NEWNAME+".txt"
Of = open(FN,"w+")
for j in range(len(DATE_ROW[0])):
for i in range(len(DATE_ROW)):
if DATE_ROW[i][j] is None:
continue
else:
Of.write("%s" %DATE_ROW[i][j])
if(i != len(DATE_ROW)-1):
Of.write(" ")
else:
Of.write("\n")
# Of.write("%s " %DATE_ROW[0][j])
# Of.write("%s\n" %DATE_ROW[1][j])
Of.close()
return FN
def ROW_COL(filename1, filename2):
if (filename1[0] == "/"):
filename1 = filename1
elif ((filename1[0] == "C") & (filename1[1] == ":")):
filename1 = filename1
else:
filename1 = os.getcwd(
) + "/" + filename1 # get the path included filename
loca1 = len(filename1)
for i in range(1, len(filename1) + 1): # find the "/" location
if (filename1[-i] == "/"):
loca1 = i - 1
break
FILENAME1 = filename1.replace(filename1[:-loca1],
"") # this is the shorten filename
filename1_No_Txt = FILENAME1.replace(".txt", "")
infile1 = filename1
if (filename2[0] == "/"):
filename2 = filename2
elif ((filename2[0] == "C") & (filename2[1] == ":")):
filename2 = filename2
else:
filename2 = os.getcwd(
) + "/" + filename2 # get the path included filename
loca2 = len(filename2)
for i in range(1, len(filename2) + 1): # find the "/" location
if (filename2[-i] == "/"):
loca2 = i - 1
break
FILENAME2 = filename2.replace(filename2[:-loca2],
"") # this is the shorten filename
filename2_No_Txt = FILENAME2.replace(".txt", "")
infile2 = filename2
COL_LIST1 = MakeList_column(infile1)
COL_LIST2 = MakeList_column(infile2)
COL_LIST1.append(COL_LIST2[1])
COL_LIST3 = COL_LIST1
# print(COL_LIST3)
ROW_LIST4 = []
for k in range(len(COL_LIST3[0])):
gg = []
for m in range(len(COL_LIST3)):
gg.append(COL_LIST3[m][k])
ROW_LIST4.append(gg)
# print(ROW_LIST4)
NEWNAME = infile1.replace(".txt", "_" + filename2_No_Txt)
FN = NEWNAME + ".txt"
Of = open(FN, "w+")
for i in range(len(ROW_LIST4)):
for j in range(len(ROW_LIST4[i])):
Of.write("%s" % ROW_LIST4[i][j])
if (j != len(ROW_LIST4[i]) - 1):
Of.write(" ")
if (j == len(ROW_LIST4[i]) - 1):
Of.write("\n")
Of.close()
return FN
