Yrurtj

I have 2 files with the following data:

file 1

22:50:48] Return_M

22:50:49] Return_A

22:50:50] Return_F

22:50:51] Return_K

22:50:52] Return_Y

file 2

22:50:48] <0> X led_required

22:50:48] <0> X start_rules

22:50:48] <0> X leadstart

22:50:49] <0> X asynchronous_start

22:50:49] <0> X controldown

22:50:49] <0> X select_set(3)

22:50:49] <0> X limiting_rules

22:50:50] <0> X stock_manager

22:50:50] <0> X led_blink

22:50:50] <0> X start_required 

22:50:51] <0> X control_down

22:50:51] <0> X select_set(3)

22:50:51] <0> X start_rules

22:50:52] <0> X stock_manager

22:50:52] <0> X blink_led

I want to have a single file that outputs the following:

22:50:48] Return_M <0> X led_required

22:50:48] Return_M <0> X start_rules

22:50:48] Return_M <0> X leadstart

22:50:49] Return_A <0> X asynchronous_start

22:50:49] Return_A <0> X controldown

22:50:49] Return_A <0> X select_set(3)

22:50:49] Return_A <0> X limiting_rules

22:50:50] Return_F <0> X stock_manager

22:50:50] Return_F <0> X led_blink

22:50:50] Return_F <0> X start_required 

22:50:51] Return_K <0> X control_down

22:50:51] Return_K <0> X select_set(3)

22:50:51] Return_K <0> X start_rules

22:50:52] Return_Y <0> X stock_manager

22:50:52] Return_Y <0> X blink_led

It basically puts the return codes from file 1 into file 2 to but only at the matching time.

Here is a Python script that should do what you want:

#!/usr/bin/env python3

# -*- encoding: utf-8 -*-

"""prefix_join.py"""



import sys



input_1 = sys.argv[1]

input_2 = sys.argv[2]



# Initialize a list to store prefixes as they occur

prefix_list = list()



# Parse the first input file

data_1 = dict()

with open(input_1, "r") as file_1:

    for line in file_1:



        # Remove trailing and leading whitespace

        line = line.strip()



        # Split the string on the first whitespace character

        prefix, sep, suffix = line.partition(" ")



        # Add the prefix the list of prefixes

        if prefix not in prefix_list:

            prefix_list.append(prefix)



        # Add the prefix to the first data dictionary

        if prefix not in data_1:

            data_1[prefix] = list()



        # Add the suffix to the data dictionary

        data_1[prefix].append(suffix)



# Parse the second input file

data_2 = dict()

with open(input_2, "r") as file_2:

    for line in file_2:



        # Remove trailing and leading whitespace

        line = line.strip()



        # Split the string on the first whitespace character

        prefix, sep, suffix = line.partition(" ")



        # Add the prefix the list of prefixes

        if prefix not in prefix_list:

            prefix_list.append(prefix)



        # Add the prefix to the first data dictionary

        if prefix not in data_2:

            data_2[prefix] = list()



        # Add the suffix to the data dictionary

        data_2[prefix].append(suffix)



# Output the joined data

for prefix in prefix_list:

    for value_1 in data_1.get(prefix, list()):

        for value_2 in data_2.get(prefix, list()):

            output_line = "{} {} X {}".format(prefix, value_1, value_2)

            print(output_line)

You would run it like this:

python prefix_join.py file-1.txt file-2.txt

On your example data, it produces the following output:

22:50:48] Return_M X <0> X led_required

22:50:48] Return_M X <0> X start_rules

22:50:48] Return_M X <0> X leadstart

22:50:49] Return_A X <0> X asynchronous_start

22:50:49] Return_A X <0> X controldown

22:50:49] Return_A X <0> X select_set(3)

22:50:49] Return_A X <0> X limiting_rules

22:50:50] Return_F X <0> X stock_manager

22:50:50] Return_F X <0> X led_blink

22:50:50] Return_F X <0> X start_required

22:50:51] Return_K X <0> X control_down

22:50:51] Return_K X <0> X select_set(3)

22:50:51] Return_K X <0> X start_rules

22:50:52] Return_Y X <0> X stock_manager

22:50:52] Return_Y X <0> X blink_led