![]() Import pandas, a lovely data analytics library, in the first line of your program: Launch the iPython QtConsole, an expanded and improved Python interpreter. Download Anaconda, a kickass Python distribution with tons of excellent packages for science and analytics. Install pip and homebrew, if you don’t already have them: Here’s the quickest and cleanest solution I found. ![]() And if you want to court madness and failure, you can try converting to a CSV file and using the LOAD DATA INFILE LOCAL command, but it’s quite labor-intensive and the documentation leaves a lot to be desired. The quick-and-dirty sqlizer.io works fine for small tables, but it was overwhelmed by my 30k row x 19 column worksheet. I am a dedicated Mac user, but it did sting a bit to discover that Windows users have the easy and convenient MySQL for Excel tool to turn their Excel docs into MySQL tables, while no such support is offered for Excel on Macs or other systems.
0 Comments
Leave a Reply. |