<jupyter_start><jupyter_text>Advanced Querying or Periodic Table Quiz<jupyter_code>from mendeleev import Element, IonizationEnergy, OxidationState, Isotope, get_session
session = get_session()
ans = session.query(Element.name).filter(Element.atomic_number == 8).all()
print(ans)
ans = session.query(Element.name).filter(Element.atomic_number > 100).all()
print(ans)<jupyter_output><empty_output><jupyter_text>Get all the elements order with respect to increasing covalent radius<jupyter_code>ans = session.query(Element).filter(Element.covalent_radius != None).order_by(Element.covalent_radius)
for a in ans:
    print("{:3s} {:15s} {:>6.2f}".format(a.symbol, a.name, a.covalent_radius))<jupyter_output><empty_output><jupyter_text>* largest, smallest, (min, max)* how many (count)  Get all the elements whose first ionization energy is smaller that 5 eV<jupyter_code>ans = session.query(Element).join(IonizationEnergy).filter(IonizationEnergy.degree == 1).\
                                                    filter(IonizationEnergy.energy < 5).all()
for a in ans:
    print a.symbol, a.ionenergies[1]
ans = session.query(Element).join(OxidationState).filter(OxidationState.oxidation_state. == 1).all()
for a in ans:
    print(a.symbol)<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.12628255722178375, 'fraction_numerical': 0.011049723756906077, 'mean_word_length': 5.436548223350254, 'pattern_counts': {'":': 0, '<': 14, '<?xml version=': 0, '>': 15, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '3', 'dir': 'jupyter-structured-clean-dedup', 'id': '271613', 'license': 'MIT', 'n_tokens_mistral': 437, 'n_tokens_neox': 407, 'n_words': 83, 'path': 'notebooks/querying.ipynb', 'repo_name': 'lmmentel/mendeleev', 'size': '1267'}