Create csv file with 4 columns for process mining

[thomaskissas33]

Hello
I try little to work with python and process mining. so i try to create a file from a text with 4 columns case id , name, process and time but my problem is that my code put it on same column on csv - excel file wich i dont want it. I want to put them on 4 different columns and same the titles.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

import re import pandas as pd   # Sample text paragraph (replace with your actual text) text_paragraph = """ Character: Maria Case1 - 2023-11-01 09:00 AM: Started the process Character: George Case2 - 2023-11-01 10:30 AM: Joined the project Character: Maria Case1 - 2023-11-01 11:45 AM: Continued working Character: George Case2 - 2023-11-01 12:15 PM: Left for a meeting """   # Initialize variables to store event data event_data = {     'Case ID': [],     'Character': [],     'Process': [],     'Time': [] }   # Use regular expressions to extract character, case ID, process, and time information event_pattern = r"(Character: (.+)|Case(\d+) - (\d{4}-\d{2}-\d{2} \d{2}:\d{2} [APM]{2}): (.+))" matches = re.findall(event_pattern, text_paragraph)   current_character = None   for match in matches:     character, case_id, timestamp, process = match[1], match[2], match[3], match[4]       if character:         current_character = character     else:         event_data['Character'].append(current_character)         event_data['Case ID'].append(case_id)         event_data['Time'].append(timestamp)         event_data['Process'].append(process)   # Create a DataFrame from the event data df = pd.DataFrame(event_data)   # Save the DataFrame as a CSV file df.to_csv('process_mining_data_4_columns.csv', index=False)

[deanhystad]

Unless told otherwise, re patterns only match a single line. Your pattern has two lines, so you should use a MULTILINE pattern.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

import re import pandas as pd     text_paragraph = """ Character: Maria Case1 - 2023-11-01 09:00 AM: Started the process Character: George Case2 - 2023-11-01 10:30 AM: Joined the project Character: Maria Case1 - 2023-11-01 11:45 AM: Continued working Character: George Case2 - 2023-11-01 12:15 PM: Left for a meeting """   event_pattern = re.compile(     r"^Character: (.+)\nCase(\d+) - (\d{4}-\d{2}-\d{2} \d{2}:\d{2} [APM]{2}): (.+)",     re.MULTILINE ) df = pd.DataFrame(     re.findall(event_pattern, text_paragraph),     columns=["Character", "Case Num", "Time", "Process"] ) print(df)

Output:
  Character Case Num                 Time              Process
0     Maria        1  2023-11-01 09:00 AM  Started the process
1    George        2  2023-11-01 10:30 AM   Joined the project
2     Maria        1  2023-11-01 11:45 AM    Continued working
3    George        2  2023-11-01 12:15 PM   Left for a meeting

[thomaskissas33]

ok thank you. but can i save it as csv file with the above data and 4 columns with titles and data?

[deanhystad]

I don't understand the question. The code from your first post wrote a CSV file. I just ran your code and the CSV file looks like this:

Output:
Case ID,Character,Process,Time
1,Maria,Started the process,2023-11-01 09:00 AM
2,George,Joined the project,2023-11-01 10:30 AM
1,Maria,Continued working,2023-11-01 11:45 AM
2,George,Left for a meeting,2023-11-01 12:15 PM

4 columns with titles. Please describe how this is not what you want.