hi, im new, i need put many column in Y, but i cant, only show 1 column= A1, but i need show: a1+a2+a3…
z= year(2018,2019, 2020)
x= month(january, february…)
please help me.
Mi code:
import plotly.graph_objects as go
import plotly.express as px
import pandas as pd
df = pd.read_csv('matlab2.csv')
df.head(13)
año mes a1 a2 a3 a4 a5 a6 a7 a8 ... a127 a128 a129 a130 a131 a132 a133 a134 a135 a136
0 2018 enero 335 253 326 346 266 280 552 1 ... 0 0 0 0 0 0
1 2018 febrero 233 208 298 278 309 307 387 131 ... 0 0 0 0 0 0
2 2018 marzo 196 177 351 356 317 333 376 105 ... 0 0 0 0 0 0
3 2018 abril 146 235 379 283 175 337 310 123 ... 0 0 0 0 0 0 0
4 2018 mayo 145 232 422 461 95 387 322 135 ... 0 0 0 0 0 0
5 2018 junio 131 220 328 300 139 348 314 216 ... 0 0 0 0 0 0 0
6 2018 julio 149 218 354 291 272 242 339 191 ... 0 0 0 0 0 0 0
7 2018 agosto 135 224 295 281 209 325 340 172 ... 0 0 0 0 0 0
8 2018 septiembre 152 205 294 235 193 271 248 86 ... 0 0 0 0 0
9 2018 octubre 154 246 312 257 324 284 284 511 ... 0 0 0 0 0 0
10 2018 noviembre 211 209 262 269 154 283 408 439 ... 0 0 0 0 0 0
11 2018 diciembre 90 125 163 235 82 291 309 201 ... 0 0 0 0 0 0
12 2019 enero 267 264 301 391 114 204 430 104 ... 0 0 0 0 0 0
mesall=df.iloc[0:26,1]
yearall=df.iloc[0:26,0]
clien=df.iloc[0:26,2:4]
fig = px.scatter_3d(df, x=yearall, z=clien, y=mesall,width=800, height=800 )
fig.show()
ValueError: Wrong number of items passed 2, placement implies 1
working only chosse one colum:
fig = px.scatter_3d(df, x=yearall, z='a1', y=mesall,width=800, height=800 )
fig.show()