<jupyter_start><jupyter_text>Method for doing more detailed slicing on multi-indexes<jupyter_code># idx = pd.IndexSlice
# df.loc[:, idx[:, "OPEN"]]<jupyter_output><empty_output><jupyter_text>Slightly cleaner syntax with less flexibility<jupyter_code>df_open = df.xs("OPEN", level="metric", axis=1)
df_vol = df.xs("VOL", level="metric", axis=1)
df_val = df_open*df_vol
df_open.plot(figsize=(16, 9))
df_vol.plot(figsize=(16, 9))
df_val.plot(figsize=(16, 9))<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.1670103092783505, 'fraction_numerical': 0.02268041237113402, 'mean_word_length': 9.565217391304348, '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': '180639', 'license': 'Apache-2.0', 'n_tokens_mistral': 199, 'n_tokens_neox': 193, 'n_words': 33, 'path': 'notebooks/.ipynb_checkpoints/tph_20190519-checkpoint.ipynb', 'repo_name': 'rtoole13/quantiac', 'size': '485'}