<jupyter_start><jupyter_text>1. Read the data.2. Ignore rows with no importance.3. Take the square of must_should_nice_to_have in order to obtain a more clear distinction when visualizing.<jupyter_code>df = pd.read_csv('some_company.csv', sep=';')
df.head()

df = df[df.would_you_x != 0]
df['must_should_nice_to_have'] = df['must_should_nice_to_have'].transform(func=lambda x: x*x)

#display(df)<jupyter_output><empty_output><jupyter_text>Draw the sunburst diagram. It is meant to visualize the state of the IT ecosystem of the company based on 'gut feeling' ratings (that is why only three values are advised to consider (0, 1 or 2) as improvability indicator). Use this diagram in discussions for prioritizations for example.<jupyter_code>fig = px.sunburst(df, path=['IT ecosystem', 'category', 'would_you_like_to_question'], values='must_should_nice_to_have',
                  color='improvability_indicator', color_discrete_map={0:'green', 1:'orange', 2:'red'},
                  color_continuous_scale=[[0, 'green'], [0.5, 'orange'], [1, 'red']])
fig.show()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.1253430924062214, 'fraction_numerical': 0.012808783165599268, 'mean_word_length': 5.8375, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '2', 'dir': 'jupyter-structured-clean-dedup', 'id': '292277', 'license': 'MIT', 'n_tokens_mistral': 370, 'n_tokens_neox': 352, 'n_words': 100, 'path': 'notebook.ipynb', 'repo_name': 'jdjong/it_ecosystems_health', 'size': '1093'}