How to extract the table of Batteries from the Battery Explorer

Materials Project
1

I am a master’s student working on a sustainability project focused on battery analysis. I am trying to extract the full CSV file of the table containing the 6,847 batteries, but I have not been able to obtain it as provided in the web page. Access to the complete CSV would be very useful, as I plan to analyze the data in Python for my project. Any guidance on how to extract or access the full dataset would be greatly appreciated.

2

Hey @Daniel_Rojas you can download the full dataset using our python client mp_api (docs). Internally, all our data is JSON format, but you can convert relevant subsets of it to CSV as needed:

from mp_api.client import MPRester
import pandas as pd

with MPRester(use_document_model=False) as mpr:
    elec_docs = mpr.materials.insertion_electrodes.search()
battery_data = pd.DataFrame(elec_docs)

If you really need CSV, then you can always do battery_data.to_csv("mp_battery_data.csv")