Plotting already sorted histogram data stored in a panda dataframe
1
I have a .csv file with histogram data in it, already binned & normalised which i read into a panda dataframe df:
Freq
0.4
0.0
0.0
0.0
0.01
0.05
0.1
0.04
0.05
0.05
0.02
0.08
0.10
0.03
0.07
I would like to plot this in a cumulative distribution histogram using matplotlib, but the pyplot.hist sorts the data and bins it again - which is not what I want.
plt.hist(df.loc[(data_tor['Freq'], cumulative = True)
Can anyone tell me how to do this?
python pandas matplotlib histogram binning
edited Nov 14 '18 at 11:30
Joe
6,08421430
asked Nov 14 '18 at 10:23
abinitioabinitio
15111
add a comment |
1
I have a .csv file with histogram data in it, already binned & normalised which i read into a panda dataframe df:
Freq
0.4
0.0
0.0
0.0
0.01
0.05
0.1
0.04
0.05
0.05
0.02
0.08
0.10
0.03
0.07
I would like to plot this in a cumulative distribution histogram using matplotlib, but the pyplot.hist sorts the data and bins it again - which is not what I want.
plt.hist(df.loc[(data_tor['Freq'], cumulative = True)
Can anyone tell me how to do this?
python pandas matplotlib histogram binning
edited Nov 14 '18 at 11:30
Joe
6,08421430
asked Nov 14 '18 at 10:23
abinitioabinitio
15111
From the data, the binning in use isn't obvious. Once you have the binning that has been used to create the dataframe you may plot a bar plot from the bins and the data.
– ImportanceOfBeingErnest
Nov 14 '18 at 10:27
add a comment |
1
1
1
I have a .csv file with histogram data in it, already binned & normalised which i read into a panda dataframe df:
Freq
0.4
0.0
0.0
0.0
0.01
0.05
0.1
0.04
0.05
0.05
0.02
0.08
0.10
0.03
0.07
I would like to plot this in a cumulative distribution histogram using matplotlib, but the pyplot.hist sorts the data and bins it again - which is not what I want.
plt.hist(df.loc[(data_tor['Freq'], cumulative = True)
Can anyone tell me how to do this?
python pandas matplotlib histogram binning
edited Nov 14 '18 at 11:30
Joe
6,08421430
asked Nov 14 '18 at 10:23
abinitioabinitio
15111
I have a .csv file with histogram data in it, already binned & normalised which i read into a panda dataframe df:
Freq
0.4
0.0
0.0
0.0
0.01
0.05
0.1
0.04
0.05
0.05
0.02
0.08
0.10
0.03
0.07
I would like to plot this in a cumulative distribution histogram using matplotlib, but the pyplot.hist sorts the data and bins it again - which is not what I want.
plt.hist(df.loc[(data_tor['Freq'], cumulative = True)
Can anyone tell me how to do this?
python pandas matplotlib histogram binning
python pandas matplotlib histogram binning
edited Nov 14 '18 at 11:30
Joe
6,08421430
asked Nov 14 '18 at 10:23
abinitioabinitio
15111
edited Nov 14 '18 at 11:30
Joe
6,08421430
asked Nov 14 '18 at 10:23
abinitioabinitio
15111
edited Nov 14 '18 at 11:30
Joe
6,08421430
edited Nov 14 '18 at 11:30
Joe
6,08421430
edited Nov 14 '18 at 11:30
Joe
6,08421430
6,08421430
asked Nov 14 '18 at 10:23
abinitioabinitio
15111
asked Nov 14 '18 at 10:23
abinitioabinitio
15111
asked Nov 14 '18 at 10:23
abinitioabinitio
15111
15111
From the data, the binning in use isn't obvious. Once you have the binning that has been used to create the dataframe you may plot a bar plot from the bins and the data.
– ImportanceOfBeingErnest
Nov 14 '18 at 10:27
add a comment |
From the data, the binning in use isn't obvious. Once you have the binning that has been used to create the dataframe you may plot a bar plot from the bins and the data.
– ImportanceOfBeingErnest
Nov 14 '18 at 10:27
From the data, the binning in use isn't obvious. Once you have the binning that has been used to create the dataframe you may plot a bar plot from the bins and the data.
– ImportanceOfBeingErnest
Nov 14 '18 at 10:27
From the data, the binning in use isn't obvious. Once you have the binning that has been used to create the dataframe you may plot a bar plot from the bins and the data.
– ImportanceOfBeingErnest
Nov 14 '18 at 10:27
add a comment |
1 Answer
1
active
oldest
votes
3
You can use:
df['Freq'].cumsum().plot(drawstyle='steps')
And to fill under the curve:
ax = df['Freq'].cumsum().plot(drawstyle='steps')
ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
answered Nov 14 '18 at 10:41
JoeJoe
6,08421430
Great - thanks. Supplementary question: Do you know how to fill under the plot?
– abinitio
Nov 14 '18 at 11:07
@abinitio You are welcome! Use:ax = df['Freq'].cumsum().plot(drawstyle='steps')ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
– Joe
Nov 14 '18 at 11:26
1
Great stuff - thanks!
– abinitio
Nov 14 '18 at 11:29
Note for future readers: This answer is correct if the binning that has been used starts at -1 which is pretty uncommon.
– ImportanceOfBeingErnest
Nov 14 '18 at 12:21
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53297905%2fplotting-already-sorted-histogram-data-stored-in-a-panda-dataframe%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
3
You can use:
df['Freq'].cumsum().plot(drawstyle='steps')
And to fill under the curve:
ax = df['Freq'].cumsum().plot(drawstyle='steps')
ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
answered Nov 14 '18 at 10:41
JoeJoe
6,08421430
Great - thanks. Supplementary question: Do you know how to fill under the plot?
– abinitio
Nov 14 '18 at 11:07
@abinitio You are welcome! Use:ax = df['Freq'].cumsum().plot(drawstyle='steps')ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
– Joe
Nov 14 '18 at 11:26
1
Great stuff - thanks!
– abinitio
Nov 14 '18 at 11:29
Note for future readers: This answer is correct if the binning that has been used starts at -1 which is pretty uncommon.
– ImportanceOfBeingErnest
Nov 14 '18 at 12:21
add a comment |
3
You can use:
df['Freq'].cumsum().plot(drawstyle='steps')
And to fill under the curve:
ax = df['Freq'].cumsum().plot(drawstyle='steps')
ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
answered Nov 14 '18 at 10:41
JoeJoe
6,08421430
Great - thanks. Supplementary question: Do you know how to fill under the plot?
– abinitio
Nov 14 '18 at 11:07
@abinitio You are welcome! Use:ax = df['Freq'].cumsum().plot(drawstyle='steps')ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
– Joe
Nov 14 '18 at 11:26
1
Great stuff - thanks!
– abinitio
Nov 14 '18 at 11:29
Note for future readers: This answer is correct if the binning that has been used starts at -1 which is pretty uncommon.
– ImportanceOfBeingErnest
Nov 14 '18 at 12:21
add a comment |
3
3
3
You can use:
df['Freq'].cumsum().plot(drawstyle='steps')
And to fill under the curve:
ax = df['Freq'].cumsum().plot(drawstyle='steps')
ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
answered Nov 14 '18 at 10:41
JoeJoe
6,08421430
You can use:
df['Freq'].cumsum().plot(drawstyle='steps')
And to fill under the curve:
ax = df['Freq'].cumsum().plot(drawstyle='steps')
ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
answered Nov 14 '18 at 10:41
JoeJoe
6,08421430
edited Nov 14 '18 at 11:28
answered Nov 14 '18 at 10:41
JoeJoe
6,08421430
answered Nov 14 '18 at 10:41
JoeJoe
6,08421430
answered Nov 14 '18 at 10:41
JoeJoe
6,08421430
6,08421430
Great - thanks. Supplementary question: Do you know how to fill under the plot?
– abinitio
Nov 14 '18 at 11:07
@abinitio You are welcome! Use:ax = df['Freq'].cumsum().plot(drawstyle='steps')ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
– Joe
Nov 14 '18 at 11:26
1
Great stuff - thanks!
– abinitio
Nov 14 '18 at 11:29
Note for future readers: This answer is correct if the binning that has been used starts at -1 which is pretty uncommon.
– ImportanceOfBeingErnest
Nov 14 '18 at 12:21
add a comment |
Great - thanks. Supplementary question: Do you know how to fill under the plot?
– abinitio
Nov 14 '18 at 11:07
@abinitio You are welcome! Use:ax = df['Freq'].cumsum().plot(drawstyle='steps')ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")
– Joe
Nov 14 '18 at 11:26
1
Great stuff - thanks!
– abinitio
Nov 14 '18 at 11:29
Note for future readers: This answer is correct if the binning that has been used starts at -1 which is pretty uncommon.
– ImportanceOfBeingErnest
Nov 14 '18 at 12:21
Great - thanks. Supplementary question: Do you know how to fill under the plot?
– abinitio
Nov 14 '18 at 11:07
Great - thanks. Supplementary question: Do you know how to fill under the plot?
– abinitio
Nov 14 '18 at 11:07
@abinitio You are welcome! Use:
ax = df['Freq'].cumsum().plot(drawstyle='steps') ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")– Joe
Nov 14 '18 at 11:26
@abinitio You are welcome! Use:
ax = df['Freq'].cumsum().plot(drawstyle='steps') ax.fill_between(df.index, 0, df['Freq'].cumsum(), step="pre")– Joe
Nov 14 '18 at 11:26
1
1
Great stuff - thanks!
– abinitio
Nov 14 '18 at 11:29
Great stuff - thanks!
– abinitio
Nov 14 '18 at 11:29
Note for future readers: This answer is correct if the binning that has been used starts at -1 which is pretty uncommon.
– ImportanceOfBeingErnest
Nov 14 '18 at 12:21
Note for future readers: This answer is correct if the binning that has been used starts at -1 which is pretty uncommon.
– ImportanceOfBeingErnest
Nov 14 '18 at 12:21
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53297905%2fplotting-already-sorted-histogram-data-stored-in-a-panda-dataframe%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
From the data, the binning in use isn't obvious. Once you have the binning that has been used to create the dataframe you may plot a bar plot from the bins and the data.
– ImportanceOfBeingErnest
Nov 14 '18 at 10:27