Forum Discussion

bkanderso's avatar
bkanderso
Helper I
3 years ago

Need Assistance In Writing Conditional Statement to Achieve The Desired Results. Please Read Below

Any help with this is greatly appreciated.   I have a chart (Strip plot) I created using Python in Power BI. The markers (Stars) represent schools. The data points are values (Y-Axis) that range fr...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi bkanderso ,

Please review the following links, hope they can help you.

Stripplot using Seaborn in Python

seaborn.set(style = 'whitegrid')
  
tips = seaborn.load_dataset("tips")
  
seaborn.stripplot(x="day", y="total_bill", hue="smoker",
                  data=tips, palette="Set1", size=20,
                  marker="s", alpha=0.2)
  
plt.show()

 

Conditional formatting of plotly scatterplot markers

trace = go.Scatter(
    x=df['x'],
    y=df['y'],
    mode='markers',
    marker=dict(
        size=42,
        # I want the color to be green if lower_limit ≤ y ≤ upper_limit
        # else red
        color=np.where(np.logical_and(df['lower_limit'] <= df['y'], df['y']  <= df['upper_limit']), 'green', 'red'),
    )
)

And you can provide some raw data in the field [UnitType] and [UnitScore] and your expected result with the screenshot, later we will check on it and give you a suitable solution. Thank you.

Best Regards

bkanderso's avatar
bkanderso
Helper I
3 years ago

Rena

 

I appreciate you taking the time to look at this.

 

I tried your suggestion (code) and it still is not giving me what I need.  I am attaching the code with my attempt to get the desired results.  I believe I need to create a data frame for Unit and Rating and Unit Score of <= 0, and then insert the data frame into the strip plot code using an conditional statement. I do not know where or how to do this.  West coast units (markers) will be blue in color with blue border, East coast markers will be gold with blue border.  If a unit has a rating less than or equal to (<=) zero I want the border for those markers (units) to be red, else West coast units (markers) will be blue in color with blue border, East coast markers will be gold with blue border.  If a unit has a payband with a score less than or equal to (<=) zero I want the fill for those markers (units) to be a hatch pattern (++) with blue border, else West coast units (markers) will be blue in color with blue border, East coast markers will be gold with blue border.  My attempt to write the data frame and conditional statements is incorrect and I am hoping you can help me get this over the finish line.

 

Here is the code:

# dataset = pandas.DataFrame(Phase, UnitCoast, Unit, Payband, Rating, UnitScore)
# dataset = dataset.drop_duplicates()

# Paste or type your script code here:

#import libraries
import matplotlib.pyplot as plt
import seaborn as sns
import pandas as pd

from matplotlib.pyplot import text

df = pd.DataFrame(dataset, columns=["Unit", "Rating", 'UnitScore']

df_rating = np.where(df['Rating'])

plt.figure(figsize=(45,22))
st=sns.stripplot(x='Phase', y='UnitScore', hue='UnitCoast', data=dataset, size=28,
    if df_rating
        marker="*", edgecolor=('Red'),
    else
        edgecolor=('Blue'), linewidth=1, alpha=1, jitter=.0)
    )  
)
plt.yticks(fontsize=30)
sns.set(font_scale=1.6)

plt.axhline(1, color="Green", linewidth=3)
matplotlib.pyplot.text(x=-.9, y=1, s='Deployment', fontsize=20)
plt.axhline(.4, color="Orange", linestyle='dashed', linewidth=3)
matplotlib.pyplot.text(x=-.9, y=.4, s='Min Target', fontsize=20)
plt.axhline(0, color="Red", label='Hard Deck', linewidth=3)
matplotlib.pyplot.text(x=-.9, y=0, s='Hard Deck', fontsize=20)


plt.xlabel('Phase', fontsize=30);
plt.ylabel('UnitScore', fontsize=30);
plt.tick_params(axis='both', which='major', labelsize=20)

x=dataset['Phase'].values
y=dataset['UnitScore'].values
z=dataset['Unit'].values

for ph, us, un in zip(x, y, z😞
    plt.annotate(un, (ph,us), xytext=(10,2), textcoords="offset points")

plt.show()
Here is a screen shot of what I want the visual to show. The vertical dashed line is a page break, doesnt belong in the visual.
 

 

Here is a screenshot of the visual in Power BI without the conditional statement.