Subrat's Technical Blog

  Embed Jupyter into Microsoft Excel and write Python instead of VBA It used to be an “either/or” choice between Excel and  Python Jupyter Notebooks . With the introduction of the  PyXLL-Jupyter  package now you can use both together, side by side. In this article I’ll show you how to set up Jupyter Notebooks running  inside  Excel. Share data between the two and even call Python functions written in your Jupyter notebook from your Excel workbook! Jupyter Notebooks in Microsoft Excel. Video by Author. Getting Started First off, to run Python code in Exce l  you need  the PyXLL add-in . The PyXLL add-in is what lets us integrate Python into Excel and use Python instead of VBA. To install the PyXLL Excel add-in “pip install pyxll” and then use the PyXLL command line tool to install the Excel add-in: >> pip install pyxll >> pyxll install If you’re new to PyXLL then take a look at the  online documentation for first time users  t...

  Legally Free Python Books List   January 29, 2020     Abdur-Rahmaan Janhangeer   book   free   legal   python Here is my personal list of legally free Python books.  Warning: Packt free books are highly unreliable, what can be free today can no longer be free tomorrow They were included as they are free at the time of writing this post. Similarly is Oreilly’s case. The two publishing houses have been annotated as necessary.  In case of no longer free or broken links please mail me at `arj.python at gmail dot com` to update article. I have to thank the internet who took the pain to point these resources to me. I have skimmed through the contents to producs a list of legally free Python books of value. Here’s how i evaluated books (you might not agree, but that’s my personal take on it): Some popular listed books like Python Module of the Week is not a book and Tango with Django 1.7 is outdated. Materials which provide only some free cha...