Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Create a matrix from a .csv file
Forum Updated to NodeBB v4.3 + New Features

Create a matrix from a .csv file

Scheduled Pinned Locked Moved Solved General and Desktop
140 Posts 2 Posters 59.5k Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    mrjj
    Lifetime Qt Champion
    wrote on 30 May 2020, 23:08 last edited by mrjj
    #24

    1:
    alt text
    Choose New file or Project

    2:
    alt text
    Select C++ class

    3:
    Give it a name and set base class to Qwidget
    alt text

    press NEXT, and then next again.

    4:
    we now have the new class and its cpp and .h added to the project
    alt text

    Lets add PaintEvent and MousePress

    Right click the name of the class in the .h file (MatrixWidget)
    and select the Refactor menu and add virtual function
    alt text

    Now type Paint in top
    and check the paintEvent function
    make sure the Insert option is as shown

    alt text

    Dont press OK yet!

    now type Press in top (where you had paint)
    and find the MousePress function and check that.

    Now Press ok.

    Then we are back to the code with our new functions.
    alt text

    Press F4 to switch to cpp file and see it has given you the bodies also.

    alt text

    Now you made your custom widget. ( it might seems a lot first time, but its very fast when used to it :)

    So next part is to add code to paintEvent to draw something.
    We also need your old reader code to get the data and stuff into our structure.

    A 1 Reply Last reply 30 May 2020, 23:21
    0
    • M Offline
      M Offline
      mrjj
      Lifetime Qt Champion
      wrote on 30 May 2020, 23:14 last edited by
      #25

      hi
      I hope the above did work for you.
      If yes. Next step is the structure to hold the data.

      
      struct DataPoint {
          int x;
          int y;
          bool value;
          QColor DrawColor; // we change this from selected / not selected.
          bool isSelected; // we set this when we click on it.
      };
      
      const int max_x = 14;
      const int max_y = 21;
      
      class MatrixWidget : public QWidget
      {
          Q_OBJECT
          DataPoint Data[max_x][max_y];  /// this is where we want to load the data to
      public:
          explicit MatrixWidget(QWidget *parent = nullptr);
      
      signals:
      
      
          // QWidget interface
      protected:
          virtual void mousePressEvent(QMouseEvent *event) override;
          virtual void paintEvent(QPaintEvent *event) override;
      };
      
      1 Reply Last reply
      1
      • M mrjj
        30 May 2020, 23:08

        1:
        alt text
        Choose New file or Project

        2:
        alt text
        Select C++ class

        3:
        Give it a name and set base class to Qwidget
        alt text

        press NEXT, and then next again.

        4:
        we now have the new class and its cpp and .h added to the project
        alt text

        Lets add PaintEvent and MousePress

        Right click the name of the class in the .h file (MatrixWidget)
        and select the Refactor menu and add virtual function
        alt text

        Now type Paint in top
        and check the paintEvent function
        make sure the Insert option is as shown

        alt text

        Dont press OK yet!

        now type Press in top (where you had paint)
        and find the MousePress function and check that.

        Now Press ok.

        Then we are back to the code with our new functions.
        alt text

        Press F4 to switch to cpp file and see it has given you the bodies also.

        alt text

        Now you made your custom widget. ( it might seems a lot first time, but its very fast when used to it :)

        So next part is to add code to paintEvent to draw something.
        We also need your old reader code to get the data and stuff into our structure.

        A Offline
        A Offline
        AliM93
        wrote on 30 May 2020, 23:21 last edited by AliM93
        #26

        sorry ok i put the function

        M 1 Reply Last reply 30 May 2020, 23:25
        0
        • A AliM93
          30 May 2020, 23:21

          sorry ok i put the function

          M Offline
          M Offline
          mrjj
          Lifetime Qt Champion
          wrote on 30 May 2020, 23:25 last edited by
          #27

          @AliM93
          Thats the Insert Option part
          alt text

          Default its on something else.

          But no worries.

          Do you have them in .h with body also like
          alt text

          If yes, then click on the function name and go to the refactor menu again ( or press alt+enter)
          alt text
          and ask it to move it to .CPP
          do for both functions.

          1 Reply Last reply
          1
          • A Offline
            A Offline
            AliM93
            wrote on 30 May 2020, 23:27 last edited by AliM93
            #28

            @mrjj the code that you wrote me i have to write into .h or .cpp? into the .h i suppose
            we need my previous code to read the data from csv?

            M 1 Reply Last reply 30 May 2020, 23:36
            0
            • A AliM93
              30 May 2020, 23:27

              @mrjj the code that you wrote me i have to write into .h or .cpp? into the .h i suppose
              we need my previous code to read the data from csv?

              M Offline
              M Offline
              mrjj
              Lifetime Qt Champion
              wrote on 30 May 2020, 23:36 last edited by
              #29

              @AliM93 said in Create a matrix from a .csv file:

              • the code that you wrote me i have to write into .h or .cpp? into the .h i suppose
                Yes the DataPoint class goes into .h as shown higher up.

              we need my previous code to read the data from csv?

              Yes, this has to be changed to add the values to the
              DataPoint Data[max_x][max_y];
              please post it.

              1 Reply Last reply
              0
              • A Offline
                A Offline
                AliM93
                wrote on 30 May 2020, 23:47 last edited by AliM93
                #30
                  csvModel = new QStandardItemModel(this);
                  csvModel->setColumnCount(3);
                  csvModel->setHorizontalHeaderLabels(QStringList() <<"x" <<y"" << "bool");
                  ui->tableView_1->setModel(csvModel);
                  
                  QFile file("/home/alice/catkin_ws/src/agree_gui/resources/Punti_tappetino.csv");
                  if(!file.open(QFile::ReadOnly | QFile::Text))
                  {
                    qDebug()<< "FIle not exist";
                    
                  }
                  else {
                    QTextStream in(&file);
                    while (!in.atEnd())
                    {
                      QString line = in.readLine();
                      QList<QStandardItem *>standardItemsList;
                      for(QString item:line.split(";"))
                        
                    }
                    csvModel ->insertRow(csvModel->rowCount(), standardItemsList);
                  }
                  file.close();
                ```this is in the .cpp file, and in the .h i put 
                

                QStandardItemsModel *csvModel;

                
                
                
                there are also some include in the cpp : 
                

                #include <QTableView>

                #include <iostream>
                #include <fstream>
                #include <sstream>

                
                and om the .h 
                

                #include <QStandardItemModel>

                1 Reply Last reply
                0
                • M Offline
                  M Offline
                  mrjj
                  Lifetime Qt Champion
                  wrote on 30 May 2020, 23:54 last edited by mrjj
                  #31

                  Hi
                  Super
                  Now we add a new function to our new class.
                  lets call it LoadData.

                  add these to the .cpp 
                  #include <QFile>
                  #include <QTextStream>
                  #include <QDebug>
                  
                  // this is changed version of your reader code
                  void MatrixWidget::LoadData()
                  {
                      QFile file("/home/alice/catkin_ws/src/agree_gui/resources/Punti_tappetino.csv");
                      if (!file.open(QFile::ReadOnly | QFile::Text)) {
                          qDebug() << "FIle not exist";
                  
                      } else {
                          QTextStream in(&file);
                          while (!in.atEnd()) {
                              QString line = in.readLine();
                              QStringList list = line.split(";");
                              int x = list.at(0).toInt();
                              int y = list.at(1).toInt();
                              bool value = list.at(2).toInt();
                              if ( x < max_x && y < max_y) // to make sure we dont crash
                                  Data[x][y].value = value; // here we store value
                              else
                                  qDebug() << "x or y bigger than matrix!";
                          }
                  
                      }
                      file.close();
                  }
                  
                  

                  Do you follow so far ?
                  I have not tried this before so not sure how easy its to follow :)

                  A 1 Reply Last reply 30 May 2020, 23:56
                  1
                  • M mrjj
                    30 May 2020, 23:54

                    Hi
                    Super
                    Now we add a new function to our new class.
                    lets call it LoadData.

                    add these to the .cpp 
                    #include <QFile>
                    #include <QTextStream>
                    #include <QDebug>
                    
                    // this is changed version of your reader code
                    void MatrixWidget::LoadData()
                    {
                        QFile file("/home/alice/catkin_ws/src/agree_gui/resources/Punti_tappetino.csv");
                        if (!file.open(QFile::ReadOnly | QFile::Text)) {
                            qDebug() << "FIle not exist";
                    
                        } else {
                            QTextStream in(&file);
                            while (!in.atEnd()) {
                                QString line = in.readLine();
                                QStringList list = line.split(";");
                                int x = list.at(0).toInt();
                                int y = list.at(1).toInt();
                                bool value = list.at(2).toInt();
                                if ( x < max_x && y < max_y) // to make sure we dont crash
                                    Data[x][y].value = value; // here we store value
                                else
                                    qDebug() << "x or y bigger than matrix!";
                            }
                    
                        }
                        file.close();
                    }
                    
                    

                    Do you follow so far ?
                    I have not tried this before so not sure how easy its to follow :)

                    A Offline
                    A Offline
                    AliM93
                    wrote on 30 May 2020, 23:56 last edited by AliM93
                    #32

                    @mrjj yes i understand all the flow! super clear, so far.

                    M 1 Reply Last reply 31 May 2020, 00:02
                    0
                    • A AliM93
                      30 May 2020, 23:56

                      @mrjj yes i understand all the flow! super clear, so far.

                      M Offline
                      M Offline
                      mrjj
                      Lifetime Qt Champion
                      wrote on 31 May 2020, 00:02 last edited by
                      #33

                      @AliM93
                      Super!
                      Could you open Punti_tappetino.csv in textEditor and copy it to say
                      https://paste.ofcode.org/
                      and give me url ?
                      Then i also have some real data to read it to check loaddata works :)

                      A 1 Reply Last reply 31 May 2020, 00:04
                      1
                      • M mrjj
                        31 May 2020, 00:02

                        @AliM93
                        Super!
                        Could you open Punti_tappetino.csv in textEditor and copy it to say
                        https://paste.ofcode.org/
                        and give me url ?
                        Then i also have some real data to read it to check loaddata works :)

                        A Offline
                        A Offline
                        AliM93
                        wrote on 31 May 2020, 00:04 last edited by
                        #34

                        @mrjj Done! are you seing it?

                        M 1 Reply Last reply 31 May 2020, 00:05
                        0
                        • A AliM93
                          31 May 2020, 00:04

                          @mrjj Done! are you seing it?

                          M Offline
                          M Offline
                          mrjj
                          Lifetime Qt Champion
                          wrote on 31 May 2020, 00:05 last edited by mrjj
                          #35

                          @AliM93
                          where is the url ?

                          you have to press paste it and then copy the adress from the top of browser
                          like
                          https://paste.ofcode.org/vYJiPZBPqzaDNArjpqPYE7
                          (just test)

                          A 1 Reply Last reply 31 May 2020, 00:07
                          1
                          • M mrjj
                            31 May 2020, 00:05

                            @AliM93
                            where is the url ?

                            you have to press paste it and then copy the adress from the top of browser
                            like
                            https://paste.ofcode.org/vYJiPZBPqzaDNArjpqPYE7
                            (just test)

                            A Offline
                            A Offline
                            AliM93
                            wrote on 31 May 2020, 00:07 last edited by AliM93
                            #36

                            @mrjj https://paste.ofcode.org/XLhSxBmaWcaKj2L9CapQ3s

                            sorry my bad

                            i have also to declare the function iLoadData in the .h file, right? in the private, protected or in the public slot?

                            M 1 Reply Last reply 31 May 2020, 00:10
                            0
                            • A AliM93
                              31 May 2020, 00:07

                              @mrjj https://paste.ofcode.org/XLhSxBmaWcaKj2L9CapQ3s

                              sorry my bad

                              i have also to declare the function iLoadData in the .h file, right? in the private, protected or in the public slot?

                              M Offline
                              M Offline
                              mrjj
                              Lifetime Qt Champion
                              wrote on 31 May 2020, 00:10 last edited by
                              #37

                              @AliM93
                              ah better :)
                              yes also add to public section.
                              we might call it from outside so its public.

                              A 1 Reply Last reply 31 May 2020, 00:12
                              1
                              • M mrjj
                                31 May 2020, 00:10

                                @AliM93
                                ah better :)
                                yes also add to public section.
                                we might call it from outside so its public.

                                A Offline
                                A Offline
                                AliM93
                                wrote on 31 May 2020, 00:12 last edited by
                                #38

                                @mrjj ok! but i get some trouble with the struct. invalid use of non-static data member.

                                M 1 Reply Last reply 31 May 2020, 00:15
                                0
                                • A AliM93
                                  31 May 2020, 00:12

                                  @mrjj ok! but i get some trouble with the struct. invalid use of non-static data member.

                                  M Offline
                                  M Offline
                                  mrjj
                                  Lifetime Qt Champion
                                  wrote on 31 May 2020, 00:15 last edited by
                                  #39

                                  @AliM93
                                  can you show line where it says that ยด
                                  Mine compiles fine.

                                  1 Reply Last reply
                                  1
                                  • A Offline
                                    A Offline
                                    AliM93
                                    wrote on 31 May 2020, 00:17 last edited by AliM93
                                    #40
                                    This post is deleted!
                                    M 1 Reply Last reply 31 May 2020, 00:22
                                    0
                                    • A AliM93
                                      31 May 2020, 00:17

                                      This post is deleted!

                                      M Offline
                                      M Offline
                                      mrjj
                                      Lifetime Qt Champion
                                      wrote on 31 May 2020, 00:22 last edited by mrjj
                                      #41

                                      @AliM93
                                      nope its not cmake

                                      it seems you forgot the ending of the DataPoint class ?
                                      the }; part ?

                                      struct DataPoint {
                                          int x;
                                          int y;
                                          bool value;
                                          QColor DrawColor; // we change this from selected / not selected.
                                          bool isSelected; // we set this when we click on it.
                                      };
                                      
                                      1 Reply Last reply
                                      0
                                      • A Offline
                                        A Offline
                                        AliM93
                                        wrote on 31 May 2020, 00:24 last edited by
                                        #42

                                        sorry.
                                        solved. and now in public slot :
                                        i add : void::Matrixwidget LoadData?

                                        M 1 Reply Last reply 31 May 2020, 00:27
                                        0
                                        • A AliM93
                                          31 May 2020, 00:24

                                          sorry.
                                          solved. and now in public slot :
                                          i add : void::Matrixwidget LoadData?

                                          M Offline
                                          M Offline
                                          mrjj
                                          Lifetime Qt Champion
                                          wrote on 31 May 2020, 00:27 last edited by
                                          #43

                                          @AliM93 said in Create a matrix from a .csv file:

                                          void::Matrixwidget LoadData?

                                          yes but mind the use of ::
                                          its only use outside class so in .h its just

                                          void LoadData();

                                          1 Reply Last reply
                                          1

                                          33/140

                                          31 May 2020, 00:02

                                          107 unread
                                          • Login

                                          • Login or register to search.
                                          33 out of 140
                                          • First post
                                            33/140
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups
                                          • Search
                                          • Get Qt Extensions
                                          • Unsolved