Python Forum
Plot multiple csv into one graph problem with visualize
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Plot multiple csv into one graph problem with visualize
#1
Hi everyone,
I really need an help, I created a small code to read 27 file .csv together and plot in the same graph.
In the csv files there is the time( x-axis) and 2 temperatures(y-axis), I don't understand why I get this kind of terrible graph.

import pandas as pd
from glob import glob
import matplotlib.pyplot as plt
import plotly.graph_objects as go



numFiles = 27 #Number of CSV files in your directory
separator = "," #Character that separates each value inside file
fExtension = ".csv" #Extension of the file storing the data


dataframe = sorted(glob('test*.csv'))


pd.concat((pd.read_csv(file).assign(filename = file)
           for file in dataframe), ignore_index  = True)





plt.plot(list(str(dataframe)) )
plt.show()
 
In this Url link there is the plot

https://ibb.co/dkn3jB1
Reply
#2
Today I did this
import numpy as np
import glob
import pandas as pd
import csv
import os
import matplotlib.pyplot as plt

path = (r'C:\Users\Alphinity\Desktop\Data visualization\01-07-2019')

all_files = glob.glob(os.path.join(path, 'test*.csv'))


li = []

for filename in all_files:
    df = pd.read_csv(filename, index_col=None, header=0, sep = ';')
    li.append(df)
df.dropna(inplace = True)
frame = pd.concat(li, axis=0, ignore_index=True)
 
cols = ['Time Peltier On:', 'T1', 'T2']


 
for i, row in df.iterrows():
    plt.figure(figsize=(10,10))
    plt.plot(row['Time Peltier On:'], df['T2'],label ='T2')
    plt.plot(df['Time Peltier On:'], df['T1'],label = 'T1')
    plt.ylim(-200,100)
    plt.grid(False)
    plt.xlabel('Time in Minutes',fontsize=14, fontweight='bold')
    plt.ylabel('Temperature in degree celcius',fontsize=14, fontweight='bold')
    plt.title('[Time Vs Temp]',fontsize=16, fontweight='bold')

    plt.legend()

plt.show()
But I'm getting always this problem, someone please could help me to find the solution ?
Error:
Warning (from warnings module): File "C:\Users\Alphinity\Desktop\Data visualization\01-07-2019\prova1.py", line 19 frame = pd.concat(li, axis=0, ignore_index=True) FutureWarning: Sorting because non-concatenation axis is not aligned. A future version of pandas will change to not sort by default. To accept the future behavior, pass 'sort=False'. To retain the current behavior and silence the warning, pass 'sort=True'. Traceback (most recent call last): File "C:\Users\Alphinity\Desktop\Data visualization\01-07-2019\prova1.py", line 27, in <module> plt.plot(row['Time Peltier On:'], df['T2'],label ='T2') File "C:\Program Files (x86)\Python37-32\lib\site-packages\matplotlib\pyplot.py", line 2795, in plot is not None else {}), **kwargs) File "C:\Program Files (x86)\Python37-32\lib\site-packages\matplotlib\axes\_axes.py", line 1666, in plot lines = [*self._get_lines(*args, data=data, **kwargs)] File "C:\Program Files (x86)\Python37-32\lib\site-packages\matplotlib\axes\_base.py", line 225, in __call__ yield from self._plot_args(this, kwargs) File "C:\Program Files (x86)\Python37-32\lib\site-packages\matplotlib\axes\_base.py", line 391, in _plot_args x, y = self._xy_from_xy(x, y) File "C:\Program Files (x86)\Python37-32\lib\site-packages\matplotlib\axes\_base.py", line 270, in _xy_from_xy "have shapes {} and {}".format(x.shape, y.shape)) ValueError: x and y must have same first dimension, but have shapes (1,) and (891,)
Thank you so much
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  I am getting a valueError. And not sure why? My goal is to visualize the correlation ReadytoCode 0 416 Dec-11-2023, 05:33 AM
Last Post: ReadytoCode
  Plot multiple 2D Curves in 3D stc 5 894 Jun-11-2023, 05:48 PM
Last Post: snippsat
  first time use plot - I get empty graph korenron 6 1,965 Feb-04-2023, 02:14 PM
Last Post: deanhystad
  Trying to loop through code to plot seaborn line plots across multiple subplots eyavuz21 0 1,575 Dec-05-2022, 10:46 AM
Last Post: eyavuz21
  Python Networkx: Visualize an edge weight with a bubble/circle uvw 0 1,945 Sep-01-2021, 06:26 AM
Last Post: uvw
  Unable to plot the graph as needed drunkenneo 1 6,263 May-26-2021, 11:04 AM
Last Post: cygnus_X1
  Multiple Plotting in Same PLot quest 0 1,777 Apr-18-2021, 10:29 AM
Last Post: quest
  How to plot 3D graph of non numerical value? Gevni 0 2,186 Mar-05-2021, 02:50 PM
Last Post: Gevni
  Python Matplotlib: How do I plot lines with different end point in the same graph? JaneTan 0 1,551 Feb-28-2021, 11:56 AM
Last Post: JaneTan
  Plot Graph quest_ 2 2,084 Jan-18-2021, 07:58 PM
Last Post: quest_

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020