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

Create a matrix from a .csv file

Scheduled Pinned Locked Moved Solved General and Desktop
140 Posts 2 Posters 51.3k Views
  • 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.
  • A AliM93

    This post is deleted!

    mrjjM Offline
    mrjjM Offline
    mrjj
    Lifetime Qt Champion
    wrote on last edited by
    #21

    @AliM93
    Ah sorry my bad.
    You have an UI file with it and inside that it says its still a QDialog so that what it complains about
    So you must open that UI in text editor and change type ( Creator should be close)
    or remove that it has one.
    That is matrix.h line 23
    and also the setupUI thing and the ui thing line 20

    Its hard to show when you use images for code.

    So do you need UI file ?
    To add other widgets on top of grid ?

    A 1 Reply Last reply
    0
    • mrjjM mrjj

      @AliM93
      Ah sorry my bad.
      You have an UI file with it and inside that it says its still a QDialog so that what it complains about
      So you must open that UI in text editor and change type ( Creator should be close)
      or remove that it has one.
      That is matrix.h line 23
      and also the setupUI thing and the ui thing line 20

      Its hard to show when you use images for code.

      So do you need UI file ?
      To add other widgets on top of grid ?

      A Offline
      A Offline
      AliM93
      wrote on last edited by
      #22

      @mrjj what if i do from new? maybe more clear for me to learn something. and sorry fro the images, up to now i will paste the code.

      mrjjM 1 Reply Last reply
      0
      • A AliM93

        @mrjj what if i do from new? maybe more clear for me to learn something. and sorry fro the images, up to now i will paste the code.

        mrjjM Offline
        mrjjM Offline
        mrjj
        Lifetime Qt Champion
        wrote on last edited by
        #23

        @AliM93
        Yes lets do a clean widget. I think its good to learn as Creator can really help in this.
        give me 5. ill make some shots.

        1 Reply Last reply
        1
        • mrjjM Offline
          mrjjM Offline
          mrjj
          Lifetime Qt Champion
          wrote on 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
          0
          • mrjjM Offline
            mrjjM Offline
            mrjj
            Lifetime Qt Champion
            wrote on 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
            • mrjjM mrjj

              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 last edited by AliM93
              #26

              sorry ok i put the function

              mrjjM 1 Reply Last reply
              0
              • A AliM93

                sorry ok i put the function

                mrjjM Offline
                mrjjM Offline
                mrjj
                Lifetime Qt Champion
                wrote on 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 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?

                  mrjjM 1 Reply Last reply
                  0
                  • A AliM93

                    @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?

                    mrjjM Offline
                    mrjjM Offline
                    mrjj
                    Lifetime Qt Champion
                    wrote on 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 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
                      • mrjjM Offline
                        mrjjM Offline
                        mrjj
                        Lifetime Qt Champion
                        wrote on 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
                        1
                        • mrjjM mrjj

                          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 last edited by AliM93
                          #32

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

                          mrjjM 1 Reply Last reply
                          0
                          • A AliM93

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

                            mrjjM Offline
                            mrjjM Offline
                            mrjj
                            Lifetime Qt Champion
                            wrote on 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
                            1
                            • mrjjM mrjj

                              @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 last edited by
                              #34

                              @mrjj Done! are you seing it?

                              mrjjM 1 Reply Last reply
                              0
                              • A AliM93

                                @mrjj Done! are you seing it?

                                mrjjM Offline
                                mrjjM Offline
                                mrjj
                                Lifetime Qt Champion
                                wrote on 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
                                1
                                • mrjjM mrjj

                                  @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 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?

                                  mrjjM 1 Reply Last reply
                                  0
                                  • A AliM93

                                    @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?

                                    mrjjM Offline
                                    mrjjM Offline
                                    mrjj
                                    Lifetime Qt Champion
                                    wrote on 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
                                    1
                                    • mrjjM mrjj

                                      @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 last edited by
                                      #38

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

                                      mrjjM 1 Reply Last reply
                                      0
                                      • A AliM93

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

                                        mrjjM Offline
                                        mrjjM Offline
                                        mrjj
                                        Lifetime Qt Champion
                                        wrote on 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 last edited by AliM93
                                          #40
                                          This post is deleted!
                                          mrjjM 1 Reply Last reply
                                          0

                                          • Login

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