Question for twitter! There is a web archive with 15,000 links to downloadable spreadsheets (xlsx), each representing one entity. Say each spreadsheet is 20 rows (years), and 50 variables of interest. All spreadsheets are identically formatted. How do I automate getting it all?
You could put together a pandas script to do it in about three hours if you're unfamiliar but want to learn Or pay someone to do the same in about 30m
-
-
pandas is a python module that more or less mimics R there's another module, urllib, that has functions for fetching web pages and files That's pretty much all you need, along with some simple string manipulation
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.