Click here to Skip to main content
15,905,233 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
I need to plot individual scatter plots from a csv paired with the same columns
My x-axis is 'Date' and y-axis is 'Column variable':
There are 14 individual sites and 21 columns

My csv looks like:
CSV
Date ID Aluminium Antimony....
30/04/2019 C2105 172 0.0025
28/05/2019 C2105 4.16 0.0005
25/06/2019 C2105 11.8 0.0005
29/07/2019 C2105 38.3 0.001
28/09/2019 C2105 0.54 0.0025
13/03/2019 C3505 172 0.0025
28/06/2019 C3505 4.16 0.0005
09/04/2019 C3505 11.8 0.0005
29/07/2019 C3505 38.3 0.001
28/09/2019 C3505 0.54 0.0025

So what I need is:
1 x scatterplot for C2105 for Aluminium
1 x scatterplot for C2105 for Antimony etc.
This will be repeated for each additional site.

I hope this makes sense?

What I have tried:

Python
data = pd.read_csv('GW_Water_Quality__ Total Metals by ICP-MS.csv')
x_col = "Date"
y_columns = ["Aluminium", "Antimony", "Arsenic", "Beryllium", "Barium",
             "Cadmium",	"Chromium",	"Cobalt",	"Copper",	"Lead",	"Manganese",
             "Molybdenum",	"Nickel",	"Selenium", "Silver", "Strontium",	"Uranium",
             "Vanadium", "Zinc", "Boron",	"Iron"]

for y_col in y_columns:

    figure = plt.figure
    ax = plt.gca()
    ax.scatter(data[x_col], data[y_col])
    ax.set_xlabel(x_col)
    ax.set_ylabel(y_col)
    ax.set_title("{} vs {}".format(x_col, y_col))

    plt.legend()
    plt.show()
Posted
Updated 29-Sep-22 22:38pm
v2

1 solution

You already posted this question at Scatter plot with multiple site ID's[^]. Please do not repost. If you have information to add then please use the Improve question link in your original and add the details there.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900