Fixing Empty Charts in Pyecharts When Using Pandas DataFrames

When passing a pandas DataFrame directly to Pyecharts, the chart may appear blank with only axes because pandas uses NumPy data types such as numpy.int64 and numpy.float64 , which Pyecharts does not handle specially.

The article demonstrates the issue with a sample DataFrame containing brand names and sales numbers, shows the resulting empty chart, and prints the type of a series element to illustrate the NumPy type.

df = pd.DataFrame(dict(Brand=['Apple','Huawei','Xiaomi','Oppo','Vivo','Meizu'], sales=[123,153,89,107,98,23]))
bar = (Bar()
       .add_xaxis(df['Brand'])
       .add_yaxis('', df['sales']))
bar.render_notebook()

To resolve the problem, convert the pandas Series to a plain Python list using the .tolist() method before supplying the data to Pyecharts. The corrected code creates the DataFrame, calls df['Brand'].tolist() and df['sales'].tolist() for the x‑axis and y‑axis, and renders the chart successfully.

df = pd.DataFrame(dict(Brand=['Apple','Huawei','Xiaomi','Oppo','Vivo','Meizu'], sales=[123,153,89,107,98,23]))
bar = (Bar()
       .add_xaxis(df['Brand'].tolist())
       .add_yaxis('', df['sales'].tolist()))
bar.render_notebook()