Stabilizing the error with the best answers: typeerror: empty 'dataframe': no numeric data to plot

Question

Here is the program I run:

2 3
 0 1300 1000
 1 242751149 199446827
 2 237712649 194704827
 3 16.2 23.0

df.plot()

After I run, it returns an error:

Library/Python/2.7/site-packages/pandas-0.16.2-py2.7-macosx-10.10-intel.egg/pandas/tools/plotting.pyc in _compute_plot_data(self)
  1015 if is_empty:
  1016 raise TypeError('Empty {0!r}: no numeric data to '
 -> 1017 'plot'.format(numeric_data.__class__.__name__))
  1018 
  1019 self.data = numeric_data
 
 TypeError: Empty 'DataFrame': no numeric data to plot

Does anyone have any suggestions for the problem below: typeerror: empty 'dataframe': no numeric data to plot in the python. How to correct it?

lyytutoria · Accepted Answer

The cause: The main reason of this error is that you are try ing to plot values from pandas DataFrame, but there are no numeric values shown in DataFrame. Solution: This error can simply be solved by using numeric to replace the particular column or columns that you want. Now I will create a simple dataframe with pandas and numpy to help you understand better. Let's follow it:

#creating the dataframe

import pandas as pd
import numpy as np
details=[['kofi',30,'male',1.5],['ama',43,'female',2.5]]
pf=pd.DataFrame(np.array(details),[0,1],['name','age','sex','id'])

pf #here i am calling the dataframe

name age sex id
0 kofi 30 male 1.5
1 ama 43 female 2.5

#to make your plot work you need to convert the columns that have numbers into numeric
as seen below

pf.id=pd.to_numeric(pf.id)
pf.age=pd.to_numeric(pf.age)

pf.plot.scatter(x='id',y='age')

#This should work perfectly

Hugo Chauvin · Answer

Before you start plotting, try these:

df=df.astype(float)

Sign Up

Sign In

Forgot Password

ITtutoria Latest Questions

Stabilizing the error with the best answers: typeerror: empty ‘dataframe’: no numeric data to plot