[Python] how to read a file and reformat some columns into new rows

I have data * in the following format in a text file.

x1 y1 z1 x2 y2 z2 x3 y3 z3 data1x data1y data1z data2x data2y data2z data3x data3y data3z


I'm trying to reformat the file such the output looks like this:

x1 y1 z1 data1x data1y data1z
x2 y2 z2 data2x data2y data2z
x3 y3 z3 data3x data3y data3z


I'm sure that there's a smart way to do the same using for example pandas. I tried with pivot and pivot_table, but the output wasn't quite right. Could you please help me?

• It's node coordinates and the corresponding vector field values (all floats), and in reality each row consists of 10 nodes, and there are thousands of rows in the file

This

all_data = []
with open(old_file, "r") as file1:
skip_first_row = file1.readline()

for line in file1:
line_list = line.split()

all_data.append(line_list[0:3]+line_list[30:33])
all_data.append(line_list[3:6]+line_list[33:36])
all_data.append(line_list[6:9]+line_list[36:39])


with open(new_file, "w") as file2:
write_headline = file2.write("%s\n" % headline)
for data in all_data:
file2.write(' '.join(data) + '\n')



does the job, but I'm sure there a smarter way!

Continue reading...