title: Is there any scripts available to import multiple csv files and stitch the data in terms of dates and export it to n excel file
body: <p>I want to write a python script to plot a graph from daily data ( temperature, humidity vs time (15 mins interval) stored in multiple csv files (daily basis). I want to read the entire monthly data (30 csv files), filter the columns and store the entire monthly data in a single file, in terms of Time and date to plot the graph for a month.</p>
  <p>This is the code I use to open, filter and plot the graph from a single csv file.</p>
  <pre><code>import pandas as pd
  import numpy as np
  import matplotlib.pyplot as plt
  from tkinter import filedialog
  from tkinter import *
  
  root = Tk()
  root.filename =  filedialog.askopenfilename(initialdir = &quot;/home/hebin/Documents/PV/Mitsui&quot;,title = &quot;Select file&quot;,filetypes = ((&quot;jpeg files&quot;,&quot;*.jpg&quot;),(&quot;all files&quot;,&quot;*.*&quot;)))
  print(root.filename)
  f = open(root.filename)
  df= pd.read_csv(root.filename)
  df.drop([0,1,2,3,4,5,6,7,8],inplace=True)
  df_new = df.rename(columns={'Location': 'Date', 'Unnamed: 1':'Time','testo 160 IAQ_51602514 [°C]':'Temperature [°C]','testo 160 IAQ_51602514 [%RH]':'Relative Humidity[%RH]'},
  index={'ONE': 'one','ONE': 'one','ONE': 'one','ONE': 'one'})
  %matplotlib inline
  plt.figure(figsize=(100,50))
  fig, Ax1 = plt.subplots(figsize=(25,20))
  Ax2 = Ax1.twinx()
  Ax3 = Ax1.twinx()
  Ax1.plot('Time', 'Temperature [°C]', data=df_new, linewidth=2, color='g' )
  Ax2.plot('Time', 'Relative Humidity[%RH]', data=df_new,linewidth=2,color='b')
  Ax1.grid(True)
  Ax1.set_xlabel('Time')
  Ax1.set_ylabel('Temperature [°C]', color='g')
  Ax2.set_ylabel('Relative Humidity[%RH]', color='b')
  </code></pre>
  <p>This the image of my data
  (<a href="https://i.stack.imgur.com/tHeug.png" rel="nofollow noreferrer">https://i.stack.imgur.com/tHeug.png</a>)</p>
  <p>actual data is starting from the 9th row. Each data starts from 12:00 am to 12:00 am next day.</p>