title: Scatter plot with different colors and markers from wide formatted data
body: <p>I have a set of data with different variables and I want to plot <code>&quot;Concentration at 10℃&quot;</code> against <code>&quot;Mean pH at 10&quot;</code>, <code>&quot;concentration at 17.5C&quot;</code> against <code>&quot;Mean pH at 17.5&quot;</code> and <code>&quot;concentration at 25C&quot;</code> against <code>&quot;Mean pH at 25&quot;</code> all in same graph.</p>
  <p><img src="https://i.stack.imgur.com/vTl5G.png" alt="test data" /></p>
  <pre class="lang-py prettyprint-override"><code>data = {'sample': ['24h', '1W', '2W', '3W', '5W'],
          'Concentration at 10°C': [4.36, 4.84, 7.20, 4.14, 1.09], 'Mean pH 10': [8.2, 7.9, 8.1, 8.3, 8.2],
          'concentration at 17.5°C': [4.4, 5.85, 5.35, 3.98, 1], 'Mean pH 17.5': [8.15, 8.2, 8.35, 8.4, 8.45],
          'concentration at 25°C': [3.27, 4.31, 5.74, 4.18, 2.4], 'Mean pH 25': [8.4, 8.25, 8.2, 8.15, 8.35]}
  
  df = pd.DataFrame(data)
  
    sample  Concentration at 10°C  Mean pH 10  concentration at 17.5°C  Mean pH 17.5  concentration at 25°C  Mean pH 25
  0    24h                   4.36         8.2                     4.40          8.15                   3.27        8.40
  1     1W                   4.84         7.9                     5.85          8.20                   4.31        8.25
  2     2W                   7.20         8.1                     5.35          8.35                   5.74        8.20
  3     3W                   4.14         8.3                     3.98          8.40                   4.18        8.15
  4     5W                   1.09         8.2                     1.00          8.45                   2.40        8.35
  </code></pre>
  <p>I have 15 samples, each sample has 2 features (a time point: e.g. 24h, and a temperature: e.g. 10C), I want to plot all my data together but in a way that each time point has a specific marker (e.g. all 24h represented by square) and each temperature also represented by a color (e.g. 10C by blue), this way when a reader looks at my figure and for instance sees a blue square, they know what that sample is,</p>
  <p>I've managed to plot all my data in one sample, but I am lost on how to change the marker and color of different samples.</p>
  <pre class="lang-py prettyprint-override"><code>import matplotlib.pyplot as plt
  import numpy as np
  import pandas as pd
  
  # Load Data
  df = pd.read_excel(r'C:\Users\fatemeha\Desktop\MiCoDy\WP1-spring-LR-April2021.xlsx', sheet_name=7)
  print(df)
  
  df.plot.scatter(x=['Mean concentration at 10℃','Mean concentration at 17.5C', 'Mean concentration at 25C'], y=[&quot;Mean pH at 10&quot;, &quot;Mean pH at 17.5&quot;, &quot;Mean pH at 25&quot;],
          rot=0, color=[&quot;blue&quot;] , xlabel='.', ylabel=&quot;.&quot;, marker=4,
          title=&quot;pH change in Lake Rot Mesocosms in Spring 2021&quot;)
  </code></pre>