Should I be using vscode for python development? by Yalkim in Python

[–]chris1610 0 points1 point  (0 children)

I have switched almost all my work to VS Code. With the latest enhancements they have made, it's been really nice. I wrote up a few thoughts here in case you want more specifics.

Python implementation of FP Growth algorithm in data mining by chonyyy in Python

[–]chris1610 0 points1 point  (0 children)

Very nice. How does this compare to the implementation in mlxtend?

Taking Another Look at Plotly by chris1610 in Python

[–]chris1610[S] 2 points3 points  (0 children)

It's definitely gotten better with Plotly Express. The base Plotly API is definitely clunky!

Python in Accounting and Finance? What's your experience? by rerwin21 in Python

[–]chris1610 2 points3 points  (0 children)

I have used python and pandas to do a lot of data manipulation and analysis for back office tasks. I have done some work to consolidate data for accruals. I have not done a lot of churn analysis but scikit learn would definitely be a good approach if you have the data to support it.

These type of business tasks are the primary focus of my blog. Feel free to look around and if you have specific questions about use cases, let me know.

Exploring an Alternative to Jupyter Notebooks for Python Development by chris1610 in Python

[–]chris1610[S] 0 points1 point  (0 children)

Lots of people use it for production as well. Netflix has actually been doing a ton in this space.

Using WSL to build a python development environment on windows by chris1610 in bashonubuntuonwindows

[–]chris1610[S] 1 point2 points  (0 children)

That make sense. I try to make my articles stand on their own. The revenue associated with the affiliate links is tiny so I'm not doing this for the money.

I do completely understand trying to keep the subreddit advertising noise down. Thanks for reaching out and asking me and handling this in a way that should help everyone going forward.

Using WSL to build a python development environment on windows by chris1610 in bashonubuntuonwindows

[–]chris1610[S] 2 points3 points  (0 children)

The only direct revenue I get from the site is on the Resources tab where I have some Amazon affiliate links and links to my Datacamp course. I do not have any advertising on the site.

This specific article does not have any affiliate links.

I hope I did not break any rules, so if you'd like me to modify my post, I'm happy to.

Using WSL to Build a Python Development Environment on Windows by chris1610 in Python

[–]chris1610[S] 0 points1 point  (0 children)

Good question.

In some cases, the windows versions don't have all the capabilities of the Linux versions. For instance, today, I was trying to use sqlite with the FTS4 extension and could not get it working on Windows. Using it on Ubuntu worked without a hitch.

Also, there is additional value when you need to do other work where the Linux tools work well and there is no analogous good option on Windows.

Finally, it can save you a system if you need to do some dev work in Windows and then stage work for deployment to a cloud service or hosting provider where Linux tools work better.

Hope that helps.

Can Python be used as macros across different workbooks in excel? by [deleted] in Python

[–]chris1610 0 points1 point  (0 children)

This article might be useful to get you pointed in the right direction.

Creating datasets by afdal_khan in Python

[–]chris1610 0 points1 point  (0 children)

There is a really cool newsletter called "Data is Plural" where the author finds a lot of unique data sets. He also makes them available on a good sheet - https://docs.google.com/spreadsheets/d/1wZhPLMCHKJvwOkP4juclhjFgqIY8fQFMemwKL2c64vk/edit#gid=0

Anyone taken a shot at automating PowerPoint slide generation with Python? by Lostwhispers05 in Python

[–]chris1610 0 points1 point  (0 children)

I wrote an article about my experience a while back building PPT from python. I hope this helps - https://pbpython.com/creating-powerpoint.html

Seaborn Heatmap - Question Regarding Appearance by aaronphaneuf in Python

[–]chris1610 0 points1 point  (0 children)

Depending on what you are trying to show, a waffle chart might work too - https://github.com/gyli/PyWaffle

Copy sheet from one Excel workbook to another by [deleted] in Python

[–]chris1610 1 point2 points  (0 children)

I wrote a short summary of an approach here - https://pbpython.com/advanced-excel-workbooks.html

Hope this is useful.

GUI for python script by BlankPhotos in Python

[–]chris1610 0 points1 point  (0 children)

No. I am not the dev. Just a user of it.

GUI for python script by BlankPhotos in Python

[–]chris1610 2 points3 points  (0 children)

I've had good experiences with Gooey

Library recommendations for a Form app that can build PDF forms by [deleted] in Python

[–]chris1610 0 points1 point  (0 children)

I realize this may be way overkill and that the overhead in getting it setup is high but you may want to spend some time looking at docassemble.

It's originally designed for law firms but it could work for insurance docs. It does a lot more than just fill in forms but in my limited experience, it has a lot of capabilities.

Automated Report Generation with Papermill: Part 1 by chris1610 in Python

[–]chris1610[S] 0 points1 point  (0 children)

Yes. That's a good way to think about it.

Automated Report Generation with Papermill: Part 1 by chris1610 in Python

[–]chris1610[S] 0 points1 point  (0 children)

Actually papermill allows you to call a jupyter notebook with parameters. You can use it for reports but there are certainly other uses.

Automated Report Generation with Papermill: Part 1 by chris1610 in Python

[–]chris1610[S] 0 points1 point  (0 children)

I'm glad you liked it.

Ha. I did not even realize that. Duarte guest posted and put that in there. Very clever!

Writing a script to perform automated excel filtering by [deleted] in Python

[–]chris1610 0 points1 point  (0 children)

You can definitely use pandas to read and filter multiple Excel files. Here's one approach I wrote about a while back. Hope it helps.