- Jun 4, 2013
Why did I not get a notification for this?Well, I'm not an expert or anything of the sort, I've just seen references mostly
You can control excel from python, so essentially you can do your normal script - which interacts with software, websites, scraping from websites, and then within the script state exactly how you want it to interact with excel.
Googling for python excel permutation seems to bring up a lot of results.
That's pretty cool. I'm bookmarking that pandas thing.
I actually asked my advisor today how he got good at scripting. He said it's all about doing and not learning. He didn't do bootcamps or anything. He just picked it up and started playing around with it.
Man, if I could figure out how to automate barcharts from matrices in Excel, I think I could get paid a lot of money for that script. Get the python pipeline to spit out the right matrix and then get Excel to incorporate that matrix, get the proper means, std dev, and std errors, then get a barchart of all the correct things. Shit, I'll be making a lot of money from that.