Skip to main content

Read csv file with multiple columns and plot data using matplotlib

Is there an easy way to read a csv file and plot an undefined(csv file changes) number of columns using pandas, matplotlib, and pyqt5? I'm a super beginner to programming so any help would be awesome! I've tried finding articles online to help, but I'm very lost.

The plot I'm trying to create has an x-axis based on time with the format '%d-%m-%Y %H:%M:%S.%f' located in column 0 of the csv file and the y-axis changes depending on the column heading starting with column 1. Example:

Timestamp, O63ME, O63MT, 011KT, etc...

11/06/2020 11:04:00.196, 34, 24, 11, etc...

14/06/2020 11:04:00.449, 114, 29, 3.84, etc...

This is what I have so far:

from PyQt5.QtCore import *
from PyQt5.QtGui import *
from PyQt5.QtWidgets import *
from matplotlib.backends.backend_qt5agg import FigureCanvasQTAgg, NavigationToolbar2QT as Navi
from matplotlib.figure import Figure
import matplotlib.pyplot as plt
import pandas as pd

class MyCanvas(FigureCanvasQTAgg):
    def __init__(self,parent=None, dpi = 120):
        fig = Figure(dpi = dpi)
        self.axes = fig.add_subplot(111)
        super(MyCanvas,self).__init__(fig)
        fig.tight_layout()
    
class MyWindow(QMainWindow):
    def __init__(self):
        QMainWindow.__init__(self)

        self.main_widget = QWidget(self)
        
        """create open button for window"""
        open_button =QPushButton('Open')
        open_button.clicked.connect(self.get_file)
        
        """empty canvas"""
        self.canv = MyCanvas(self)
        
        """create toolbar to control plot"""
        self.toolbar = Navi(self.canv,self.main_widget)
        
        """set layout of window"""
        self.grid = QGridLayout(self.main_widget)
        self.grid.addWidget(open_button, 0,0)
        self.grid.addWidget(self.toolbar,0,1)
        self.grid.addWidget(self.canv,1,0)
        
        self.main_widget.setFocus()
        self.setCentralWidget(self.main_widget)

    def get_file(self):
        getFile(self)
        
class openFunction():
    def __init__(self):
        self.filename = ''
        self.df = []
        
    def getFile(self):
        self.filename = QFileDialog.getOpenFileName(filter = "csv (*.csv)")[0]
        self.readData()
        
    def readData(self):
        self.df = pd.read_csv(instance.filename,encoding = 'utf-8').fillna(0)    

    def plot(self):
        plt.clf()
        plt.plot(df[0:],df[1:])
        

if __name__ == '__main__':

    import sys
    app = QApplication(sys.argv)

    w = MyWindow()
    w.setWindowTitle("Something cool goes here")
    w.show()
    app.exec_()


source https://stackoverflow.com/questions/73872655/read-csv-file-with-multiple-columns-and-plot-data-using-matplotlib
Labels:

Comments

Post a Comment

Popular posts from this blog

Why is my reports service not connecting?

I am trying to pull some data from a Postgres database using Node.js and node-postures but I can't figure out why my service isn't connecting. my routes/index.js file: const express = require('express'); const router = express.Router(); const ordersCountController = require('../controllers/ordersCountController'); const ordersController = require('../controllers/ordersController'); const weeklyReportsController = require('../controllers/weeklyReportsController'); router.get('/orders_count', ordersCountController); router.get('/orders', ordersController); router.get('/weekly_reports', weeklyReportsController); module.exports = router; My controllers/weeklyReportsController.js file: const weeklyReportsService = require('../services/weeklyReportsService'); const weeklyReportsController = async (req, res) => { try { const data = await weeklyReportsService; res.json({data}) console...
Post a Comment
Read more

How to show number of registered users in Laravel based on usertype?

i'm trying to display data from the database in the admin dashboard i used this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count(); echo $users; ?> and i have successfully get the correct data from the database but what if i want to display a specific data for example in this user table there is "usertype" that specify if the user is normal user or admin i want to user the same code above but to display a specific usertype i tried this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count()->WHERE usertype =admin; echo $users; ?> but it didn't work, what am i doing wrong? source https://stackoverflow.com/questions/68199726/how-to-show-number-of-registered-users-in-laravel-based-on-usertype
Post a Comment
Read more

The number of nodes and edges I calculated manually and by a method provided by networkx library dont match

I am trying to analyse a graph using networkx library in Python. I have implemented a function that returns the nodes and edges of that graph. After that I counted the number of nodes and edges by implementing the len() function for nodes and edges, which gave me 17 for both nodes and edges. However, when I used the method graph.number_of_nodes() of networkx library it gave me 53. My code: import pandas as pd import networkx as nx import matplotlib.pyplot as plt header_list = ["a","b","w"] E =pd.read_csv("aves-barn-swallow-contact-network.edges",sep=" ",header= None,names=header_list) # print(E.head()) # prints first few rows of the csv file G = nx.from_pandas_edgelist(E,"a","b",["w"]) nx.draw(G) plt.show() class GraphAnalyse: #finding nodes and edges def nodeEdge(self,Graph): nodes = Graph.nodes() edges = Graph.edges() ...
Post a Comment
Read more