Plotly Histogram only showing a fraction of my data with Spyder

Viewed 20

I am having trouble using Plotly with Spyder. I used Pandas to create multiple data frames, each of which was pulled from an excel sheet(23 excels in total). All the excels are identical in format. Then, using a for loop, each one is concatenated into a df_all. However, I used a fig = go.Figure(go.Histogram2d to show the df_all that has a range that can fit all the data. I specified the bin size, but not all data shows in the fig.write_html that I exported using plotly.

I guess my question is there a data limit for how much plotly can export a visual as a html? (Note my df_all size is (117074, 7). I only needed two columns)

If there isn't how would I specify in Spyder how much it can render

I'll attach the script used for creating the histogram

fig = go.Figure(go.Histogram2d(
x = df_all['Velocity'],
y = df_all['grade'],
xbins=dict(start = 5.0, end = 60.0, size = 1.0), 
ybins=dict(start=2, end=14, size=.25)))

fig.add_trace(go.Scatter(
x = rpc_df['Velocity'], y = rpc_df['grade'],
mode = 'lines'))

I hope this makes sense. Forgive if my jargon does not sense to a experienced programmer.

0 Answers
Related