matplotlib graph legend is in reverse order (barh)

2018-09-23 17:23 TheCrystalShip imported from Stackoverflow

I have 15 graphs that looks like this:

As you see, the legend is in reverse order. I want to see 4 first, below that 3 etc.

My code:

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
def plot_bars_by_data(data, title):
    fig, axs = plt.subplots(8,2, figsize=(20,40))
    fig.suptitle(title, fontsize=20)
    fig.subplots_adjust(top=0.95)
    plt.rcParams.update({'font.size': 13})
    axs[7,1].remove()

    column_index = 0
    for ax_line in axs:
        for ax in ax_line:
            if column_index < len(data.columns): 
                column_name = data.columns[column_index]
                current_column_values = data[column_name].value_counts().sort_index()
                axx = ax.barh([str(i) for i in current_column_values.index], 
                              list(current_column_values.values), 
                              color=[colors[i] for i in range(data[column_name].value_counts().count())])
                ax.legend(axx, [str(i) for i in current_column_values.index])
                ax.set_title(column_name)
                column_index +=1

    plt.show()

# random data
df_test = pd.DataFrame([np.random.randint(2,5,size=15) for i in range(15)], columns=list('abcdefghijlmnop'))
plot_bars_by_data(df_test, "testing")

I tried to just reverse the legend list, but it is reversing the colors as well. I'm using Python 3.6 in Jupyter python notebook. Any ideas?

See also questions close to this topic

Convert column into Json using Dataframe(python)

        [{
                    "customer_name": "ABI2",
                    "location_name": "Cherai2",
                    "employee_name": "ASU2",
                    "Sales_Plan_Details": "[{\"Month\": \"2019-1\", \"Quantity\": 10, \"Product_Gid\": 3}]"

    },
{
                "customer_name": "ABI",
                "location_name": "Cherai",
                "employee_name": "ASU",
                "Sales_Plan_Details": "[{\"Month\": \"2019-1\", \"Quantity\": 10, \"Product_Gid\": 3}]"

}]

Python

 plan_get = pd.DataFrame(rows, columns=columns) #plan_get return all json data
return Response({"MESSAGE": "FOUND","DATA":json.loads(plan_get.to_json(orient='records'))})

Here i'm using pandas DataFrame to pass json data. My question is how would i convert Sales_Plan_Details(column) to json object before returning.

gunicorn and/or celery: What is the way get the best out of both?
I've a machine learning application which uses flask to expose api(for production this is not a good idea, but even if I'll use django in future the idea of the question shouldn't change).

The main problem is how to serve multiple requests to my app. Few months back celery has been added to get around this problem. The number of workers in celery that was spawned is equal to the number of cores present in the machine. For very few users this was looking fine and was in production for some time.

When the number of concurrent users got increased, it was evident that we should do a performance testing on it. It turns out: it is able to handle 20 users for 30 GB and 8 core machine without authentication and without any front-end. Which is not looking like a good number.

I didn't know there are things like: application server, web server, model server. When googling for this problem: gunicorn was a good application server python application.
- Should I use gunicorn or any other application server along with celery and why
- If I remove celery and only use gunicorn with the application can I achieve concurrency. I have read somewhere celery is not good for machine learning applications.
- What are the purposes of gunicorn and celery. How can we achieve the best out of both.
Note: Main goal is to maximize concurrency. While serving in production authentication will be added. One front-end application might come into action in between in production.
How to dynamically add zone to bind dns server via python?

I'm new about dns concepts, I want to dynamically add zones to my bind dns server by python but i have no idea how to do that and what python package should I use. how to do this in python? thanks in advance.

MatPlotLib scatter redrawing extending x Axis

I am new to python and maplotlib. I am trying to draw a scatterplotwith matplotlib that is grouped by industry. However when I iterate over the industries and add them to the figure the output redraws and extends the axis to the right inside of reusing and rescaling the existing axis, The result makes all the tick marks unreadable and put each industry side by side and not on the same axis.

temp = data[data.Year == 2017]
data = pd.read_csv(path, encoding='latin1')
data['Company'] = pd.Categorical(data['Company'])
data['Industry'] = pd.Categorical(data['Industry'])

fig = plt.figure()
ax = fig.add_subplot(1, 1, 1)

for ind in temp.Industy.unique():
   temp2 = temp[temp.Company == ind]

   revGrowth = temp2["RevGrowth"]
   EBITMargin = temp2['EBITMargin']
   scatter_plot = ax.scatter(revGrowth, EBITMargin, s=40, alpha=0.8,label=ind)

plt.legend(loc='upper right', bbox_to_anchor=(1.3, 1.05), fontsize=8, frameon=False)
plt.xticks(rotation=90)
plt.xlabel("Revenue Growth YoY (%)")
plt.ylabel("Return on Assets (%)")
plt.title("Industry Growth vs Profitability 2017\n")
plt.tight_layout()
plt.savefig("xx")

image 1

Correlation Plot Color mismatch in Python using matplotlib

I am plotting correlation of data in python using matplotlib. The highly correlated data should be coloured dark red but it is coloured as yellow in my case. How to solve it?

My correlation data is this:

Screen shot

My code is like this:

def plot_corr(df, size=11):

Function plots a graphical correlation matrix for each pair of columns in the dataframe.

Input:
    df: pandas Dataframe
    size: vertical and horizontal size of the plot

Displays:
    matrix of correlation between columns. Blue-cyan-yellow-red-darkred => less to more correlated
                                           0 ------------------------> 1
                                           Expect a darkred line running from top left to bottom right
"""
corr = df.corr()    #data frame correlation function
fig, ax = plt.subplots(figsize=(size,size))
ax.matshow(corr)    # color code  the rectangles by correlation value
plt.xticks(range(len(corr.columns)), corr.columns)   # draw x tick marks
plt.yticks(range(len(corr.columns)), corr.columns)   # draw y tick marks

My output is like this:

Screen Shot

How to make an arrowhead point in the same direction as the arrow using matplotlib
I'm using the code
```
import matplotlib.pyplot as plt

plt.figure(1)
plt.axis(xmin=0, xmax=60, ymin=0, ymax=0.25)
plt.arrow(30, 0.01, 10, 0.1, head_width=0.05, head_length=1, length_includes_head=True)
plt.savefig('arrow.png')
```
and I expect to get an arrowhead that is pointing in the same direction the line of the arrow points. But it doesn't:

What can be done about this (and why is it happening?)

Visual Basic connected to MS Access: Button and Text box not working

I'm creating a project in the Visual Studio that accepts data and stores it to MS Access. Then a button is provided to show another form that has a data grid view of the data from the database and represent the data into graphical form. Once I had the connection of the database and the software successfully, the buttons stopped working, i cant input data in the text box, neither close the program. here is my GUI:

and my code:

Public Class main

Private Sub main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    'TODO: This line of code loads data into the '_QualiPool_1_1DataSet.Temperature' table. You can move, or remove it, as needed.
    Me.TemperatureTableAdapter.Fill(Me._QualiPool_1_1DataSet.Temperature)

End Sub

Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
    TemperatureBindingSource.AddNew()
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    TemperatureTableAdapter.Update(_QualiPool_1_1DataSet.Temperature)
    TemperatureBindingSource.EndEdit()
    MessageBox.Show("Data has been saved")
End Sub

Private Sub Button9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button9.Click
    Database.Show()
End Sub
End Class

Convert .dtl file to text with Python

The company I work for builds some simple data logging systems to monitor fluid pressure. The loggers create .dtl files and put them on a thumb drive, which the user can then take to a PC and convert to a .csv, then export to Excel so they can get a graph. I've been tasked with creating a set of instructions to give to our customers so they can do this, but it's really cumbersome to have to use 2 programs and manually do all this stuff, not to mention the users of these loggers have zero computer skills. Maybe this is way more involved than I think it is, but wouldn't it be possible to write some simple Python code to get the number values out of the .dtl and just graph them with pyplot or something? This way I can give the users one program that completely automates the process. The files will be always be the same format, and we don't need any fancy graphics. I just can't find any information on exactly how a .dtl is encoded, or how to decode it. Can someone enlighten me on what this would involve?
Limited visibility window on a dynamically update graph

I have this non trivial challenge (at least for me) to build an API to work with a data set that are sort of a graph which needs to be dynamically updated (changes in amount of vertices their properties and connections between them).

Data set has geospatial data. Connections between vertices are handled via object ids and their relations. So, it's a PostGIS database in a C++ interpretation.

An acceptable limitation is that we allow updates only for data that are "far" from currently observed location. This assumes that API limits visibility of a graph to a certain area. This limited visibility window is moving along the known trajectory.

Now, the question is how an API and internal implementation should look like in order to provide access to data (vertices, their properties and connections) in the way that we don't have to keep the trace of once initialized (and exposed via API) data for as long as program runs. Basically, a user should be able to work with data exposed via current limited visibility window and should not have access to data that have been accessible via old window but not in the current one.

Simple example of an API that would fail: expose direct access to data in graph. A user can save a raw pointer to data. Once window is moved, that pointer might become invalid but user would never know about it. Some of user pointers will still point of existing data (available via current window) when other will point to un-managed memory (cause old data has been release).

Things like shared pointers are not applicable because graph has circular connections.

ggplot single-value factor remove slashes from legend

I would like to show a simple geom_point, geom_smooth, and geom_abline with helpful legends. Unfortunately, the simple combination of geom_point and geom_smooth places a horizontal line across the point legend, adding geom_abline places a diagonal slash across all legends.

How can I create a simple visual where legend boxes include only a "point", a "line", and a "dashed line"?

Thanks

Examples:

Geom_point and geom_smooth

mtcars %>%
  ggplot() +
  geom_point(aes(x = carb, y = mpg, color = "Points")) +
  geom_smooth(aes(x = carb, y = mpg, color = "Trendline")) +
  theme(legend.position="bottom") +
  labs(x = "carb",
    y = "mpg",
    color = "LEGEND")

Geom_point, geom_smooth, and geom_abline

mtcars %>%
  ggplot() +
  geom_point(aes(x = carb, y = mpg, color = "Points")) +
  geom_smooth(aes(x = carb, y = mpg, color = "Trendline")) +
  geom_abline(aes(slope = 1, intercept = 10, color = "ZCustom"), linetype = "dashed") +
  theme(legend.position="bottom") +
  labs(x = "carb",
    y = "mpg",
    color = "LEGEND")

Fixed geom_point legend, but slashes remain on other legends

mtcars %>%
  ggplot() +
  geom_point(aes(x = carb, y = mpg, color = "Points")) +
  geom_smooth(aes(x = carb, y = mpg, color = "Trendline")) +
  geom_abline(aes(slope = 1, intercept = 10, color = "ZCustom"), linetype = "dashed") +
  scale_color_manual(values = c("red", "blue", "black"),
                 label = c("Points", "Trendline", "Custom"),
                 guide = guide_legend(override.aes = list(
                   linetype = c("blank", "solid", "dashed"),
                   shape = c(16, NA, NA)))) +
  theme(legend.position="bottom") +
  labs(x = "carb",
    y = "mpg",
    color = "LEGEND")

mtcars plot with point, smooth, abline and broken legend

I have looked at these questions but did not understand how to apply to my situation:

Define and specify legend quantiles scatter plot R

I have eg data and syntax for a scatter (jitter) plot below

eg_data <- data.frame(
period = c(sample( c("1 + 2"), 1000, replace = TRUE)),
max_sales = c(sample( c(1,2,3,4,5,6,7,8,9,10), 1000, replace = TRUE, prob = 
c(.20, .10, .15, .20, .15, .10, .05, .02, .02, .01))) )

jitter <-  (
(ggplot(data = eg_data, aes(x=period, y=max_sales)) +
geom_jitter(stat = "identity", width = .15, color = "blue", alpha = .4)) +
scale_y_continuous(breaks= seq(0,12, by=1)) +
stat_summary(fun.y = "quantile", fun.args = list(probs = c(0.25)), geom = "hline", aes(yintercept = ..y..), colour = "red", size = 1) +
stat_summary(fun.y = "mean", geom = "hline", aes(yintercept = ..y..), colour = "gold", size = 1) +
stat_summary(fun.y = "quantile", fun.args = list(probs = c(0.50)), geom = "hline", aes(yintercept = ..y..), colour = "blue", size = 1) +
stat_summary(fun.y = "quantile", fun.args = list(probs = c(0.75)), geom = "hline", aes(yintercept = ..y..), colour = "black", size = 1) +
stat_summary(fun.y = "quantile", fun.args = list(probs = c(0.90)), geom = "hline", aes(yintercept = ..y..), colour = "green", size = 1) +
ggtitle("Max Sales x Period 1 and 2") + xlab("Period") + ylab("Sales") +
theme(plot.title = element_text(color = "black", size = 14, face = "bold", hjust = 0.5),
      axis.title.x = element_text(color = "black", size = 12, face = "bold"), 
      axis.title.y = element_text(color = "black", size = 12, face = "bold")) +
labs(fill = "Period") )
jitter

I cannot find documentation on how to define a legend for the horiztonal quantile / mean lines I have in this graph.

How to add legend to ggplot manually? - R

I came across this SO question / answer but I wasn't able to implement it, when I include color inside the aes setting, it doesn't work.

EDIT - a member suggested I add color to the aes specification...here is the same graph with color and size included.

jitter2 <-  (
(ggplot(data = eg_data, aes(x=period, y=max_sales)) +
geom_jitter(stat = "identity", width = .15, color = "blue", alpha = .4)) +
scale_y_continuous(breaks= seq(0,12, by=1)) +
stat_summary(fun.y = "quantile", fun.args = list(probs = c(0.25)), geom = "hline", aes(yintercept = ..y.., colour = "red"), size = 1) +
stat_summary(fun.y = "mean", geom = "hline", aes(yintercept = ..y.., colour = "gold"), size = 1) +
stat_summary(fun.y = "quantile", fun.args = list(probs = c(0.50)), geom = "hline", aes(yintercept = ..y.., colour = "blue"), size = 1) +
stat_summary(fun.y = "quantile", fun.args = list(probs = c(0.75)), geom = "hline", aes(yintercept = ..y.., colour = "black"), size = 1) +
stat_summary(fun.y = "quantile", fun.args = list(probs = c(0.90)), geom = "hline", aes(yintercept = ..y.., colour = "green"), size = 1) +
ggtitle("Max Sales x Period 1 and 2") + xlab("Period") + ylab("Sales") +
theme(plot.title = element_text(color = "black", size = 14, face = "bold", hjust = 0.5),
      axis.title.x = element_text(color = "black", size = 12, face = "bold"), 
      axis.title.y = element_text(color = "black", size = 12, face = "bold")) +
labs(fill = "Period") )
jitter2

So...any help is appreciated. Thank you!

How to italicize part of the legend in r
I have the following code:
```
legend(x = 23, y = 40, legend = c('Col-0 Control', 'Col-0 840g ha-1', 'TOC1-ox Control', 'TOC1-ox 840g ha-1'), col = c('black', 'black','red', 'red'), lty = c(1,2,1,2 ), pch=c(15,15,15,15), cex = 1.5, bty="n", lwd=2)
```
I'm trying to get TOC1 in italics whilst leaving the -ox non-italicized and am not sure how to. I'm also trying to make the -1 in g ha-1 in superscript.

Many thanks
Is it possible to reverse engineer/compile a Lua file with a custom file structure?

I’ve been dealing with an issue where the Lua header of the file I want to decompile is not similar to any normal version of Lua, and I’m left feeling unsure on how to proceed.

My end goal is to have a compiler and decompiler for this custom version of Lua but I’m not an expert with Lua.

Is this even possible? If so, how can it be achieved.
While loop, negative #s, reverse iteration

Ex. Write a function called sum_string() that takes two arguments and produces a nicely formatted string owing the full sum of #s between and including those 2 arguments.

When formatting the 'sum string' and negative # should be in brackets (unless it is the first # in the sum string). There should be a plus sign and spaces between each pair of #s.

If the 1st # argument is larger than the 2cd,the sum sting should count backwards. The resulting integer sum is also added to the end of the string after an equal sign and spaces.

Ex. print (sum_string(-4,2)) prints: -4 + (-3) + (-2) + (-1) + 0 + 1 + 2 = -7

ex. print (sum_string(12,7)) prints: 12 + 11 + 10 + 9 + 8 + 7 = 57

How would I write the function?
How to do balance line in Cobol using 3 input files?

my challenge on class is code a program which read 3 input txt files and generate 1 txt output file. All input files must be preferentially line sequential mode and no one indexed (this are rules for breaking our minds).

File 1 has field ID-USER (ordered by it) and others; File 2 has fiels ID-USER (ordered by it), ID-JOB and others; File 3 has field ID-JOB (ordered by it) and others. Output file will join data from 3 files.

Balance line in cobol with 2 files is a hard work but I can do it. But using 3 input files, when ID-USER is corresponding in files 1 and 2, I must advance read on file 3 to record corresponding ID-JOB on files 2 and 3, and my balance line is doesn't more work because I don't know if is possible "restart" read on file 3.

Resuming: how to restart a read using sequential mode on specific input file (file 3)? Or reverse search direction on same cobol program.

Related questions

matplotlib graph legend is in reverse order (barh)

See also questions close to this topic