Saturday 15 June 2013

how to merge data present in text files without changing the format using python? -



how to merge data present in text files without changing the format using python? -

i have 3 files, file1,file2 , file3, in file1 have 3 columns 10 rows; in file2 have 1 column 15 rows; in file3 have 1 time again 1 column 10 rows. how merge files 1 file without changing format? want columns of file1, followed file2 , file3.

below code need. assume each element separated white space. code works irregular column length , there no need set 0 empty elements in shorter columns. tested simple examples.

def read_file(name): rows = open(name, 'r').readlines() info = [] r in rows: data.append(r.split()) homecoming info def invert(data): new_data = [] max_col = 0 r in data: if len(r) > max_col: max_col = len(r) col_no = max_col in range(col_no): cal = [] j in range(len(data)): if in range(len(data[j])): cal.append(data[j][i]) else: cal.append(' ') new_data.append(cal) homecoming new_data def merge(data_list): big_data = [] d in data_list: c in d: big_data.append(c) homecoming big_data def write_result(result): result_file = open('result', 'w') r in result: e in r: result_file.write(e + ' ') result_file.write('\n') data1 = read_file('file1') data2 = read_file('file2') data3 = read_file('file3') new_data1 = invert(data1) new_data2 = invert(data2) new_data3 = invert(data3) big_data = merge([new_data1, new_data2, new_data3]) result = invert(big_data) write_result(result)

python python-2.7

No comments:

Post a Comment