[CentralOH] 2017-01-30 會議 Scribbles 落書/惡文?: kindle 3 micropython cluster bim walker xlwings

[jep200404 at columbus.rr.com]

Thanks to Pillar and Chris Baker for their hospitality.

many people, over 30?

many people at brazenhead also 20?

scala spark flink

bim walker

hard stop at 8pm instead of 8:30pm
then hang out and adjourn to Brazenhead

pillar is hiring for columbus
cmm is hiring
bim's wife
    sr data scientist
    western pa
netjets? expanding analytics
jp morgan java
    they have some python

    kindle 3
        easy to jail break by drap and drop right file
            one of those images has micropython inside it

    tika
        scrape text from pdfs
        https://pypi.python.org/pypi/tika
        http://tika.apache.org/
    600 files 200k records in 2 minutes?

    some library for clustering kindles

2017-03-27
max morlocke will talk about memory leaks
jim prior will talk about using named groups for regular expressions

2017-07-29 & 2017-07-30
PyOhio 2017 @ Ohio Union
pyohio.org

###############################################################################

bim walker
xlwings

xlwings.org
big syntax revision last summer
docs.xlwings.org/en/stable/syntax_overview.html

    thin stackoverflow support

allows one to use python in excel spreadsheets

he uses ms windows

very helpful last six or eight months at work

https://www.xkcd.com/974/

pandas
    multidimensional spreadsheet

go back and forth between jupyter notebook and excel

xlsxwriter is write only
    https://pypi.python.org/pypi/XlsxWriter
    supports details of excel much better
    does not require excel to be installed
    (just knows how to write format)
xlwings requires excel to be installed on computer
    does not support libreoffice or openoffice
    pyoo is recommended
        https://pypi.python.org/pypi/pyoo

pyexcel
    https://pypi.python.org/pypi/pyexcel
    could read and write from excel sheets

excel images suck
so use images created by matplotlib

powerpoint can import directory of images
    makes it easy to update

use conda (anaconda or miniconda) for python on ms windows
    spyder: IDE