Iplot treats pandas numeric column as categorical

📊 Plotly Python
1 
    import cufflinks as cf
    import plotly.offline
    import numpy as np
    import pandas as pd
    cf.go_offline()
    cf.set_config_file(offline=False, world_readable=True)
    y_chr = np.resize(np.array(list('abc')),5)
    y_num = np.array([22000,1,3,5000,3])
    df = pd.DataFrame({'chr':y_chr,'num':y_num})
    df.iplot()

plotly
plotly.png978×410 24.4 KB

The num column of the plotted dataframe is treated as categorical: y-axis represents numbers in the order they appeared in the num column.
I’d like the ‘num’ column to be plotted as numerical.
How can it be done?

Thank you!

2

I believe the problem is that you are sharing the yaxis from your ‘chr’ column to your ‘num’ column. ‘a’,‘b’,‘c’ are all categorical, and because 22000, 1, 3, and 5000 share the same axes as it, they are being treated as categorical. I would advise against using df.iplot() in this case, and splitting the two plots apart.

1 Like