22 lines
372 B
Python
22 lines
372 B
Python
from matplotlib import pyplot as plt
|
|
import pandas as pd
|
|
|
|
|
|
import sqlite3
|
|
|
|
con = sqlite3.connect("db.sqlite3")
|
|
|
|
df = pd.read_sql_query(
|
|
"""SELECT *
|
|
FROM analizes a
|
|
JOIN control_cases c ON c.id = a.case_id
|
|
JOIN params p ON p.id = c.params_id
|
|
""",
|
|
con,
|
|
)
|
|
|
|
df2 = df.query("pe == 2").query("rel_c==1000")
|
|
|
|
plt.plot(df2["rel"], df2["psi_max"], ls="o")
|
|
plt.show()
|