Hi everybody,
I tried to create a script that produced a graph. On the x-axis is time and on the y-axis are 17 variables. Each of the variables has a different range (small values, large values). How to make it so that the y-axis in the graph is formatted so that all the variables in the graph are clearly visible. There is a similar contribution here Multiple y scales to show all data but the links are given (the solution does not suit me).
Sorry for my English and thanks for help!
Here is code:
import dash
from dash import Dash, html, dash_table, dcc, callback, Output, Input
import pandas as pd
import plotly.express as px
import numpy as np
import os,re, glob
import plotly.graph_objects as go
global numbers
numbers=re.compile(r'(\d+)')
def numericalSort(value):
parts = numbers.split(value)
parts[1::2] = map(int, parts[1::2])
return parts
path=r'C:\Users\...\Plotly_data\data_with_comma'
app = Dash(__name__)
global df
all_files = glob.glob(os.path.join(path, "*.csv"))
df = pd.concat((pd.read_csv(f,sep=',|s+',engine='python') for f in all_files), ignore_index=True)
del df['Unnamed: 19']
sel = df.columns[2:]
fig = px.line(df, x='TIME', y=df.columns[2:],render_mode='svg')
fig.update_yaxes(rangemode='normal',showgrid=True, zeroline=True, showticklabels=True,
showspikes=False,spikethickness=0.5, spikemode='across', spikesnap='cursor', showline=True, spikedash='solid',spikecolor='black')
fig.update_xaxes(showgrid=True, zeroline=True, showticklabels=True,
showspikes=False,spikethickness=0.5,spikemode='across', spikesnap='cursor', showline=True, spikedash='solid',spikecolor='black')
fig.update_traces(selector=lambda t: t.name in sel, visible='legendonly')
fig.update_layout(modebar_add=['drawline','drawopenpath','drawclosedpath','drawcircle','drawrect','eraseshape','v1hovermode', 'hoverclosest', 'hovercompare', 'togglespikelines'])
app.layout = html.Div(children=[
html.H1(children='....'),
dcc.Graph(
id='example-graph',style={'width': '180vh', 'height': '100vh'},config={'scrollZoom':True},responsive=True,
figure=fig
)
])
if __name__ == '__main__':
app.run('.........', debug=False)
And part of data file:
TIME,YEAR,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,n13,n14,n15,n16,n17,
29.07.2024 00:00:00,2024,1858.21,-0.0820355,0,23.4971,-0.0989825,2.02604e-008,2255.12,-0.171658,4.03647e-005,-0.220266,21.8317,0,24.9434,2137.01,-0.0205994,1.31707,23.3399,
29.07.2024 00:10:00,2024,1846.2,-0.115958,0,23.5431,-0.0974585,2.02332e-008,2166.04,-0.175444,4.93714e-005,-0.220266,21.8388,0,24.9852,2195.06,-0.0247192,1.31708,23.3437,
29.07.2024 00:20:00,2024,1793.13,-0.0853924,0,23.5373,-0.0988013,2.01867e-008,2179.05,-0.178242,4.20657e-005,-0.220253,21.8491,0,24.9716,2213.08,-0.0224304,1.31707,23.3358,
29.07.2024 00:30:00,2024,1751.08,-0.0880128,0,23.548,-0.0981701,2.02073e-008,2136.01,-0.184065,4.33709e-005,-0.220287,21.8568,0,25.0129,2130,-0.0439453,1.31706,23.3616,
29.07.2024 00:40:00,2024,1794.13,-0.0819973,0,23.5464,-0.0961335,2.01578e-008,2192.06,-0.184776,4.14788e-005,-0.220257,21.8646,0,25.0594,2128,-0.0183105,1.31709,23.3796,
29.07.2024 00:50:00,2024,1829.18,-0.107089,0,23.583,-0.0977724,2.0164e-008,2233.1,-0.186926,4.84866e-005,-0.220274,21.8692,0,25.0739,2152.02,-0.0183105,1.31707,23.4126,
29.07.2024 01:00:00,2024,1794.13,-0.0844977,0,23.5714,-0.0980758,2.01258e-008,2098.97,-0.190958,4.32403e-005,-0.220322,21.8759,0,25.0762,2244.11,-0.0123596,1.31707,23.3785,
29.07.2024 01:10:00,2024,1842.19,-0.104092,0,23.5839,-0.0984613,2.01051e-008,2225.09,-0.195129,4.92229e-005,-0.220295,21.8804,0,25.0422,2233.1,-0.0187683,1.31705,23.3794,
29.07.2024 01:20:00,2024,1810.15,-0.0936176,0,23.6262,-0.0988199,2.01028e-008,2174.04,-0.19706,4.64305e-005,-0.220331,21.8904,0,25.1166,2215.09,-0.0196838,1.31706,23.4283,
29.07.2024 01:30:00,2024,1819.16,-0.103548,0,23.6191,-0.0980846,2.00702e-008,2144.01,-0.200974,4.92384e-005,-0.220312,21.8943,0,25.1326,2073.95,-0.0169373,1.31707,23.3999,
29.07.2024 01:40:00,2024,1843.19,-0.0843224,0,23.6437,-0.0956142,2.00685e-008,2163.03,-0.203873,4.40828e-005,-0.220324,21.9042,0,25.1409,2177.05,-0.0196838,1.31706,23.4594,
29.07.2024 01:50:00,2024,1860.22,-0.102844,0,23.6531,-0.0972097,2.00369e-008,2182.05,-0.207912,4.96397e-005,-0.220356,21.9075,0,25.1517,2139.01,-0.015564,1.31706,23.4313,
29.07.2024 02:00:00,2024,1850.2,-0.0912716,0,23.6908,-0.0953306,2.00382e-008,2196.07,-0.211245,4.66036e-005,-0.22035,21.9136,0,25.1696,2159.03,-0.0187683,1.31707,23.4052,
29.07.2024 02:10:00,2024,1745.07,-0.0889628,0,23.6679,-0.0972378,2.00191e-008,2095.97,-0.212973,4.6675e-005,-0.220345,21.9212,0,25.2345,2175.04,-0.0169373,1.31707,23.4736,
29.07.2024 02:20:00,2024,1775.11,-0.109659,0,23.6781,-0.0963369,1.99871e-008,2211.08,-0.216568,5.18627e-005,-0.220388,21.9256,0,25.235,2148.02,-0.0224304,1.31707,23.473,
29.07.2024 02:30:00,2024,1848.2,-0.10573,0,23.7089,-0.0960971,1.99688e-008,2136.01,-0.218454,5.1287e-005,-0.22039,21.9318,0,25.2504,2234.1,-0.0187683,1.31709,23.4979,