RickyAdams.com

Anaconda – Has many essential libraries (numpy, pillow, matplotlib, csv – CSV File Reading and Writing turtle — Turtle graphics openpyxl – read/write Excel 2010 xlsx/xlsm files XlsxWriter – writing files in the Excel 2007+ XLSX file format pymysql – access/manipulate MySQL Database pyodbc and pymssql – access/manipulate an ODBC SQL database requests – read web pages beautifulsoup – read HTML pages/tags pypdf – manipulate PDF files pdfminer-six – read contents of PDFs Tkinter – Graphic User Interface library PySimpleGUI…

Read More Read More

Comparison of Various Python IDEs As of May 2017, I have only actively used Idle and Pyzo, but have tried a many more. Idle – Pyzo – Canopy – Spyder   … (more coming) Canopy Express By downloading Canopy you acknowledge your acceptance of all the terms and conditions of the applicable license. v1.7.4 Documentation Platform Python Released Size MD5 Linux [64-bit] 2.7 download 2016-07-21 619.8 MB a2510ac37a4ab3079ea4aa728ff31b0e macOS [64-bit] 2.7 download 2016-07-21 437.3 MB 889a2e2beb7dfd8e77b40ba8f603b387 Windows [64-bit] 2.7 download…

Read More Read More

xlrd 1.0.0 documentation Handling of Unicode Dates in Excel spreadsheets Named references, constants, formulas, and macros Formatting information in Excel Spreadsheets Loading worksheets on demand XML vulnerabilities and Excel files API Reference Installation Instructions Development Changes Acknowledgements Licenses xlrd Docs » xlrd 1.0.0 documentation Edit on GitHub xlrd documentation¶ xlrd is a library for reading data and formatting information from Excel files, whether they are .xls or .xlsx files.   Handling of Unicode¶ This package presents all text strings as…

Read More Read More

Installing Third-Party Modules Beyond the standard library of modules packaged with Python, other developers have written their own modules to extend Python’s capabilities even further. The primary way to install third-party modules is to use Python’s pip tool. This tool securely downloads and installs Python modules onto your computer from https://pypi.python.org/, the website of the Python Software Foundation. PyPI, or the Python Package Index, is a sort of free app store for Python modules. The pip Tool The executable file…

Read More Read More

Working with Excel Spreadsheets Excel is a popular and powerful spreadsheet application for Windows. The openpyxl module allows your Python programs to read and modify Excel spreadsheet files. For example, you might have the boring task of copying certain data from one spreadsheet and pasting it into another one. Or you might have to go through thousands of rows and pick out just a handful of them to make small edits based on some criteria. Or you might have to…

Read More Read More