How to properly plot a density heat map using lat, lon and values as magnitude?

As info if useful, I am using spyder, my data set contains 4,173,841 data points and 69 columns, the file size is 3.05 Gb (after images there is still part of the explanation of my problem).

This is the code I am using:

data=pd.read_csv('/Users/Me/Documents/Python/JAN-2021-ee.csv')    import plotly.express as px    map = px.density_mapbox(data, lat='latitude',lon='longitude',z='Total emissions',radius=10,mapbox_style="stamen-terrain")    from plotly.offline import plot  plot(map)  

This is what I get:

My aim to get something like this (built in tableau):

I have had a hard time trying to figure why I cannot get the same results or similar, any ideas I will really appreciate it! Thanks.

https://stackoverflow.com/questions/66056928/how-to-properly-plot-a-density-heat-map-using-lat-lon-and-values-as-magnitude February 05, 2021 at 10:52AM