Column Dependencies/Usage Within Applied Steps

It seems silly to reply to my own post but I thought other people might find the solution I found interesting. I was able to do it using Python coding by extracting the information from the M code using regex! 

# Import required packages
import re
import pandas as pd

# Create the variable that contains your M code
m_code = '''

    Insert your M code here

'''

# Regular expression to find all Table.AddColumn occurrences
add_column_pattern = r'Table\.AddColumn\([^)]+, "([^"]+)", each ([^)]+)\)'
matches = re.findall(add_column_pattern, m_code)

# Collect extracted dependencies
data = []
for column_name, column_expression in matches:
    # Find all references inside square brackets []
    dependency_pattern = r'\[(.*?)\]'
    
    dependencies = re.findall(dependency_pattern, column_expression)
    
    # Append results to data list
    data.append({'Column_Name': column_name, 'Dependent_On': ', '.join(set(dependencies))})

# Convert to Pandas DataFrame
df = pd.DataFrame(data)

# Display extracted dependency table
print("Extracted Dependencies Table:")
print(df.to_string(index=False))

# Export to Excel
output_file = "column_dependencies.xlsx"
df.to_excel(output_file, index=False)

print(f"Extracted Dependencies Table saved to {output_file}")