Huge CSV file with numeric and text data











up vote
3
down vote

favorite












I try to load a huge CSV file (~ 4 Gbyte), the data is both numeric and textual.

So, I can't load the data as a string.



str = OpenRead["train.csv"];

data = ReadList[str, String];


When I try to Import the file directly, my notebook is crash ( Win 10, WL 11.3, and my PC has 32G of RAM). The link to the data:
https://www.kaggle.com/c/microsoft-malware-prediction/data
To deal with this issue, I split the original file to a few parts and load each one and save in ".mx" format. Any suggestion on how to load the file in a more efficient way






list-manipulation performance-tuning







share|improve this question




























    up vote
    3
    down vote

    favorite












    I try to load a huge CSV file (~ 4 Gbyte), the data is both numeric and textual.

    So, I can't load the data as a string.



    str = OpenRead["train.csv"];
    
data = ReadList[str, String];


    When I try to Import the file directly, my notebook is crash ( Win 10, WL 11.3, and my PC has 32G of RAM). The link to the data:
    https://www.kaggle.com/c/microsoft-malware-prediction/data
    To deal with this issue, I split the original file to a few parts and load each one and save in ".mx" format. Any suggestion on how to load the file in a more efficient way






    list-manipulation performance-tuning







    share|improve this question


























      up vote
      3
      down vote

      favorite









      up vote
      3
      down vote

      favorite











      I try to load a huge CSV file (~ 4 Gbyte), the data is both numeric and textual.

      So, I can't load the data as a string.



      str = OpenRead["train.csv"];
      
data = ReadList[str, String];


      When I try to Import the file directly, my notebook is crash ( Win 10, WL 11.3, and my PC has 32G of RAM). The link to the data:
      https://www.kaggle.com/c/microsoft-malware-prediction/data
      To deal with this issue, I split the original file to a few parts and load each one and save in ".mx" format. Any suggestion on how to load the file in a more efficient way






      list-manipulation performance-tuning







      share|improve this question















      I try to load a huge CSV file (~ 4 Gbyte), the data is both numeric and textual.

      So, I can't load the data as a string.



      str = OpenRead["train.csv"];
      
data = ReadList[str, String];


      When I try to Import the file directly, my notebook is crash ( Win 10, WL 11.3, and my PC has 32G of RAM). The link to the data:
      https://www.kaggle.com/c/microsoft-malware-prediction/data
      To deal with this issue, I split the original file to a few parts and load each one and save in ".mx" format. Any suggestion on how to load the file in a more efficient way






      list-manipulation performance-tuning




      list-manipulation performance-tuning






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 1 hour ago









      Rolf Mertig

      13.7k13366




      13.7k13366










      asked 2 hours ago









      Kiril Danilchenko

      761316




      761316






















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          3
          down vote













          I recognize this when larger files and/or depending on fileformats. A brute force solution is to increase the size for the java virtual machine, for example



          `<< JLink`;InstallJava;
          
ReinstallJava[JVMArguments -> "-Xmx6144m"];`





          share|improve this answer





















          • Thank a lot, I will try this.
            – Kiril Danilchenko
            1 hour ago






          • 1




            Since you have 32GB, you can of course increase the number after "-Xm"
            – FredrikD
            28 mins ago











          Your Answer





          StackExchange.ifUsing("editor", function () {
          return StackExchange.using("mathjaxEditing", function () {
          StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
          StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
          });
          });
          }, "mathjax-editing");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "387"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmathematica.stackexchange.com%2fquestions%2f187972%2fhuge-csv-file-with-numeric-and-text-data%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          up vote
          3
          down vote













          I recognize this when larger files and/or depending on fileformats. A brute force solution is to increase the size for the java virtual machine, for example



          `<< JLink`;InstallJava;
          
ReinstallJava[JVMArguments -> "-Xmx6144m"];`





          share|improve this answer





















          • Thank a lot, I will try this.
            – Kiril Danilchenko
            1 hour ago






          • 1




            Since you have 32GB, you can of course increase the number after "-Xm"
            – FredrikD
            28 mins ago















          up vote
          3
          down vote













          I recognize this when larger files and/or depending on fileformats. A brute force solution is to increase the size for the java virtual machine, for example



          `<< JLink`;InstallJava;
          
ReinstallJava[JVMArguments -> "-Xmx6144m"];`





          share|improve this answer





















          • Thank a lot, I will try this.
            – Kiril Danilchenko
            1 hour ago






          • 1




            Since you have 32GB, you can of course increase the number after "-Xm"
            – FredrikD
            28 mins ago













          up vote
          3
          down vote










          up vote
          3
          down vote









          I recognize this when larger files and/or depending on fileformats. A brute force solution is to increase the size for the java virtual machine, for example



          `<< JLink`;InstallJava;
          
ReinstallJava[JVMArguments -> "-Xmx6144m"];`





          share|improve this answer












          I recognize this when larger files and/or depending on fileformats. A brute force solution is to increase the size for the java virtual machine, for example



          `<< JLink`;InstallJava;
          
ReinstallJava[JVMArguments -> "-Xmx6144m"];`






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 1 hour ago









          FredrikD

          9221822




          9221822












          • Thank a lot, I will try this.
            – Kiril Danilchenko
            1 hour ago






          • 1




            Since you have 32GB, you can of course increase the number after "-Xm"
            – FredrikD
            28 mins ago


















          • Thank a lot, I will try this.
            – Kiril Danilchenko
            1 hour ago






          • 1




            Since you have 32GB, you can of course increase the number after "-Xm"
            – FredrikD
            28 mins ago
















          Thank a lot, I will try this.
          – Kiril Danilchenko
          1 hour ago




          Thank a lot, I will try this.
          – Kiril Danilchenko
          1 hour ago




          1




          1




          Since you have 32GB, you can of course increase the number after "-Xm"
          – FredrikD
          28 mins ago




          Since you have 32GB, you can of course increase the number after "-Xm"
          – FredrikD
          28 mins ago


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Mathematica Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          Use MathJax to format equations. MathJax reference.


          To learn more, see our tips on writing great answers.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmathematica.stackexchange.com%2fquestions%2f187972%2fhuge-csv-file-with-numeric-and-text-data%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          -

          Popular posts from this blog

          Quarter-circle Tiles

          Image
          up vote 0 down vote favorite I have $99$ identical square tiles, each with a quarter-circle drawn on it like this: [asy] size(1.5cm); draw(Arc((2,0),1,90,180),red+1); draw((0,0)--(2,0)--(2,2)--(0,2)--(0,0)); [/asy] When I arrange the tiles in a $9times 11$ rectangular grid, each with a random orientation, what is the expected value of the number of full circles I form? I think this problem has to do with finding the chance any given 2x2 square has a circle, but I can't find it. expected-value share | cite | improve this question asked Nov 20 at 15:03 6minecraftninja 1 2
          Read more

          build a pushdown automaton that recognizes the reverse language of a given pushdown automaton?

          Image
          0 I think it's similiar to NFAs. I replace the finite states of the given automaton for start-states for my new automaton. I do it with $epsilon$ -transition from the start state to the actual finite states of the given automaton. The start state of the given automaton will be my accepting(finite) state of my new one. All transitions will be reversed of course to recognize the reversed word. But how do I have to change the stack of the pushdown automaton? That's tricky. formal-languages automata context-free-grammar share | cite | improve this question edited Nov 29 '18 at 14:20 joee
          Read more

          Mont Emei

          Image
          Mont Emei.mw-parser-output .entete.map{background-image:url("//upload.wikimedia.org/wikipedia/commons/7/7a/Picto_infobox_map.png")} Vue du sommet Wanfo du mont Emei Géographie Altitude 3 099  m , Wanfo Coordonnées 29° 31′ 11″ nord, 103° 19′ 57″ est Administration Pays   Chine Province Sichuan Ville-préfecture Leshan Géolocalisation sur la carte : Sichuan Mont Emei Géolocalisation sur la carte : Chine Mont Emei modifier   Paysage panoramique du mont Emei, incluant le paysage panoramique du grand Bouddha de Leshan *   Patrimoine mondial de l'UNESCO Passerelle en bois sur le versant ouest Pays   Chine Subdivision Sichuan Type Mixte Critères (iv) (vi) (x) Superficie 15 400 ha Numéro d’identification 779 Zone géographique Asie et Pacifique  ** Année d’inscription 1996 (20 e session) * Descriptif officiel UNESCO ** Classification géog
          Read more