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

          Ellipse (mathématiques)

          Image
          Pour les articles homonymes, voir Ellipse. L'ellipse est le lieu des points dont la somme des distances à deux points fixes, dits foyers, est constante. Section du cône ou projection du cercle. En géométrie, une ellipse est une courbe plane fermée obtenue par l’intersection d’un cône de révolution avec un plan, à condition que celui-ci coupe l'axe de rotation du cône ou du cylindre : c'est une conique d'excentricité strictement comprise entre 0 et 1. On peut également la définir comme le lieu des points dont la somme des distances à deux points fixes, dits foyers, est constante (sa construction par la méthode du jardinier est très simple). Dans la vie courante, l’ellipse est la forme qu'on perçoit en regardant un cercle en perspective, ou la figure formée par l’ombre d'un disque sur une surface plane. On retrouve aussi, en première approximation [ 1 ] , des ellipses dans les trajectoires des corps célestes (planètes, comètes ou satellites arti...
          Read more

          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

          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