Plotting from dataset in Python

Question

This must be very simple but i am not able to figure out how to do it.I am trying to plot the data present in my dataset.

Below is my code ,

import pandas as pd
import matplotlib.pyplot as plt

dataset = pd.read_csv('TipsReceivedPerMeal.csv')
plt.scatter(dataset[0],dataset[1])
plt.show()

The data in my CSV file is some random data, which specifies what tip a waiter receive at one particular day.

Data in CSV

MealNumber  TipReceived
1                    17
2                    10
3                    5
4                    7
5                    14
6                    25

Thanks in advance for the help.

what about dataset.plot(x='MealNumber', y = 'TipReceived' ..., kind='scatter). You might want to have a look at searborns facetgrid — Moritz
– Moritz, Commented Mar 14, 2017 at 10:58

ImportanceOfBeingErnest · Accepted Answer · 2017-03-14 10:43:06Z

4

Another option is to replace plt.scatter(dataset[0],dataset[1]) with

plt.scatter(dataset[[0]],dataset[[1]])

edited Mar 14, 2017 at 10:43

ImportanceOfBeingErnest

342k61 gold badges739 silver badges771 bronze badges

answered Mar 14, 2017 at 5:03

Miriam Farber

19.7k15 gold badges66 silver badges78 bronze badges

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

Comments

ImportanceOfBeingErnest · Accepted Answer · 2017-03-14 10:51:42Z

1

There are several options, some already mentionned in previous answers,

plt.scatter(dataset['MealNumber'],dataset['TipReceived']) (as mentioned by @Ankit Malik)
plt.scatter(dataset.iloc[:,0],dataset.iloc[:,1])
plt.scatter(dataset[[0]],dataset[[1]]) (as mentioned by @Miriam)

In order for those to work with the data from the question, one should use the delim_whitespace=True paramter, as otherwise the read-in would not work:

dataset = pd.read_csv('TipsReceivedPerMeal.csv', delim_whitespace=True)

answered Mar 14, 2017 at 10:51

ImportanceOfBeingErnest

342k61 gold badges739 silver badges771 bronze badges

Comments

Ankit Malik · Accepted Answer · 2017-03-15 07:06:08Z

1

Just replace: plt.scatter(dataset[0],dataset[1])

With: plt.scatter(dataset['MealNumber'],dataset['TipReceived'])

In Pandas columns can either be referenced by name or by column number with iloc.

edited Mar 15, 2017 at 7:06

answered Mar 14, 2017 at 5:01

Ankit Malik

909 bronze badges

2 Comments

ImportanceOfBeingErnest Over a year ago

Mind that dataset.iloc[0] won't work, you'd need dataset.iloc[:,0] instead.

Ankit Malik Over a year ago

@ImportanceOfBeingErnest, thanks for the comment. I have corrected it.

Collectives™ on Stack Overflow

Plotting from dataset in Python

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related