Nan values when plotting Matplotlib

Question

Hi i am trying to display a large merged data set into a scatter plot graph to find the relationship between The gdp per capita and number of kids. The dataframe looks someting like this. How do i remove the rows with Nan Values and plot the scatter? Or do i just plot the graph straight and it will ignore all rows with NaN value? Any help would be great thanks :) Also , when calculating the mean of the second and third column , do i show the result on another column?

Country | Number of kids | GDP per capita
  A     |      4         |    2345
  B     |      2         |    2156
  C     |     NaN        |    1156
  D     |     5          |    958
  E     |     NaN        |    NaN
  F     |     8          |    NaN
.
.
.
 Z      |     3          |    2

have you tried "plotting the graph straight"?

asongtoruin
– asongtoruin

2018-09-11 07:24:00 +00:00
Commented Sep 11, 2018 at 7:24 — asongtoruin
– asongtoruin, Commented Sep 11, 2018 at 7:24

paolof89 · Accepted Answer · 2018-09-11 07:17:02Z

1

Use the pandas' dropna() function to remove nan and then plot it with a scatter() plot of matplotlib.

import pandas as pd
import matplotlib.pyplot as plt
enter code here
df = <your dataset>
plot_df = df.dropna()
plt.scatter(plot_df['Number of kids'], plot_df['GDP per capita'])

If your dataset is very large consider to use the sample function to randomly sample data:

df = df.sample(1000)

answered Sep 11, 2018 at 7:17

paolof89

1,3696 gold badges19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Nan values when plotting Matplotlib

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related