Connect data points in line chart in Python
0
I defined this function in Python to plot two indicators gini and economic freedom over time.
def PlotCountry(countries):
simple = df_gini.loc[countries, :].sort_values(by = "year", ascending = True)
simple = simple.reset_index()
simple = simple.drop(['rank', '5_regulation'], axis = 1)
simple = simple.round(2)
simple.columns = ["Year", "ISO Code", "Gini Index", "Economic Freedom"]
#Plot a double-axis lineplot
fig, ax1 = plt.subplots()
color = 'darkred'
ax1.set_xlabel('Year')
ax1.set_ylabel('Gini Index', color = color)
ax1.plot("Year", "Gini Index", color = color, data = simple, linestyle='--', marker = ".")
ax1.tick_params(axis='y', labelcolor = color)
ax2 = ax1.twinx() #Instantiate second axis that shares the same x-axis
color = 'darkblue'
ax2.set_ylabel('Economic Freedom', color = color)
ax2.plot("Year", "Economic Freedom", color = color, data = simple)
ax2.tick_params(axis='y', labelcolor=color)
plt.title(countries)
fig.tight_layout() #Otherwise right y-label is slightly clipped
plt.show()
Sometimes the plot I get looks like:
How do I connect the red dots?
python matplotlib line
asked Nov 15 '18 at 2:28
Guillermina Sutter SchneiderGuillermina Sutter Schneider
11511
add a comment |
0
I defined this function in Python to plot two indicators gini and economic freedom over time.
def PlotCountry(countries):
simple = df_gini.loc[countries, :].sort_values(by = "year", ascending = True)
simple = simple.reset_index()
simple = simple.drop(['rank', '5_regulation'], axis = 1)
simple = simple.round(2)
simple.columns = ["Year", "ISO Code", "Gini Index", "Economic Freedom"]
#Plot a double-axis lineplot
fig, ax1 = plt.subplots()
color = 'darkred'
ax1.set_xlabel('Year')
ax1.set_ylabel('Gini Index', color = color)
ax1.plot("Year", "Gini Index", color = color, data = simple, linestyle='--', marker = ".")
ax1.tick_params(axis='y', labelcolor = color)
ax2 = ax1.twinx() #Instantiate second axis that shares the same x-axis
color = 'darkblue'
ax2.set_ylabel('Economic Freedom', color = color)
ax2.plot("Year", "Economic Freedom", color = color, data = simple)
ax2.tick_params(axis='y', labelcolor=color)
plt.title(countries)
fig.tight_layout() #Otherwise right y-label is slightly clipped
plt.show()
Sometimes the plot I get looks like:
How do I connect the red dots?
python matplotlib line
asked Nov 15 '18 at 2:28
Guillermina Sutter SchneiderGuillermina Sutter Schneider
11511
1
I guess you shouldn't connect the dots, since that would mean that the values in between could be interpolated. However, it seems there is data missing, which is obvious from the current plot, but not from one where they are connected. If you want to ignore this warning and possibly deliberately fool the reader of the chart, you can probably just use.dropna()on the data.
– ImportanceOfBeingErnest
Nov 15 '18 at 3:20
add a comment |
0
0
0
I defined this function in Python to plot two indicators gini and economic freedom over time.
def PlotCountry(countries):
simple = df_gini.loc[countries, :].sort_values(by = "year", ascending = True)
simple = simple.reset_index()
simple = simple.drop(['rank', '5_regulation'], axis = 1)
simple = simple.round(2)
simple.columns = ["Year", "ISO Code", "Gini Index", "Economic Freedom"]
#Plot a double-axis lineplot
fig, ax1 = plt.subplots()
color = 'darkred'
ax1.set_xlabel('Year')
ax1.set_ylabel('Gini Index', color = color)
ax1.plot("Year", "Gini Index", color = color, data = simple, linestyle='--', marker = ".")
ax1.tick_params(axis='y', labelcolor = color)
ax2 = ax1.twinx() #Instantiate second axis that shares the same x-axis
color = 'darkblue'
ax2.set_ylabel('Economic Freedom', color = color)
ax2.plot("Year", "Economic Freedom", color = color, data = simple)
ax2.tick_params(axis='y', labelcolor=color)
plt.title(countries)
fig.tight_layout() #Otherwise right y-label is slightly clipped
plt.show()
Sometimes the plot I get looks like:
How do I connect the red dots?
python matplotlib line
asked Nov 15 '18 at 2:28
Guillermina Sutter SchneiderGuillermina Sutter Schneider
11511
I defined this function in Python to plot two indicators gini and economic freedom over time.
def PlotCountry(countries):
simple = df_gini.loc[countries, :].sort_values(by = "year", ascending = True)
simple = simple.reset_index()
simple = simple.drop(['rank', '5_regulation'], axis = 1)
simple = simple.round(2)
simple.columns = ["Year", "ISO Code", "Gini Index", "Economic Freedom"]
#Plot a double-axis lineplot
fig, ax1 = plt.subplots()
color = 'darkred'
ax1.set_xlabel('Year')
ax1.set_ylabel('Gini Index', color = color)
ax1.plot("Year", "Gini Index", color = color, data = simple, linestyle='--', marker = ".")
ax1.tick_params(axis='y', labelcolor = color)
ax2 = ax1.twinx() #Instantiate second axis that shares the same x-axis
color = 'darkblue'
ax2.set_ylabel('Economic Freedom', color = color)
ax2.plot("Year", "Economic Freedom", color = color, data = simple)
ax2.tick_params(axis='y', labelcolor=color)
plt.title(countries)
fig.tight_layout() #Otherwise right y-label is slightly clipped
plt.show()
Sometimes the plot I get looks like:
How do I connect the red dots?
python matplotlib line
python matplotlib line
asked Nov 15 '18 at 2:28
Guillermina Sutter SchneiderGuillermina Sutter Schneider
11511
asked Nov 15 '18 at 2:28
Guillermina Sutter SchneiderGuillermina Sutter Schneider
11511
asked Nov 15 '18 at 2:28
Guillermina Sutter SchneiderGuillermina Sutter Schneider
11511
asked Nov 15 '18 at 2:28
Guillermina Sutter SchneiderGuillermina Sutter Schneider
11511
asked Nov 15 '18 at 2:28
Guillermina Sutter SchneiderGuillermina Sutter Schneider
11511
11511
1
I guess you shouldn't connect the dots, since that would mean that the values in between could be interpolated. However, it seems there is data missing, which is obvious from the current plot, but not from one where they are connected. If you want to ignore this warning and possibly deliberately fool the reader of the chart, you can probably just use.dropna()on the data.
– ImportanceOfBeingErnest
Nov 15 '18 at 3:20
add a comment |
1
I guess you shouldn't connect the dots, since that would mean that the values in between could be interpolated. However, it seems there is data missing, which is obvious from the current plot, but not from one where they are connected. If you want to ignore this warning and possibly deliberately fool the reader of the chart, you can probably just use.dropna()on the data.
– ImportanceOfBeingErnest
Nov 15 '18 at 3:20
1
1
I guess you shouldn't connect the dots, since that would mean that the values in between could be interpolated. However, it seems there is data missing, which is obvious from the current plot, but not from one where they are connected. If you want to ignore this warning and possibly deliberately fool the reader of the chart, you can probably just use
.dropna() on the data.– ImportanceOfBeingErnest
Nov 15 '18 at 3:20
I guess you shouldn't connect the dots, since that would mean that the values in between could be interpolated. However, it seems there is data missing, which is obvious from the current plot, but not from one where they are connected. If you want to ignore this warning and possibly deliberately fool the reader of the chart, you can probably just use
.dropna() on the data.– ImportanceOfBeingErnest
Nov 15 '18 at 3:20
add a comment |
0
active
oldest
votes
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%2f53311567%2fconnect-data-points-in-line-chart-in-python%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53311567%2fconnect-data-points-in-line-chart-in-python%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
1
I guess you shouldn't connect the dots, since that would mean that the values in between could be interpolated. However, it seems there is data missing, which is obvious from the current plot, but not from one where they are connected. If you want to ignore this warning and possibly deliberately fool the reader of the chart, you can probably just use
.dropna()on the data.– ImportanceOfBeingErnest
Nov 15 '18 at 3:20