Browsed by
Tag: Google Docs

Work programmatically with Google Spreadsheets Part 2

Work programmatically with Google Spreadsheets Part 2

A while back I wrote a short post on how you can write and read to Google Spreadsheets programmatically using Python and the package ‘gspread’. Last time the reading was done by first creating arrays with the addresses to where the values could be found in the spreadsheet, and then run through all the values and replace the addresses with the values. It worked fine, but it’s not best practice or very efficient as it makes many single requests on…

Read More Read More

Work programmatically with Google Spreadsheets

Work programmatically with Google Spreadsheets

Some time back I authored a script which reads through a CSV formatted list, and based on the artists’ names tried to decide the nationality of the artists by querying the last.FM search engine and parsing the XML structured result. The script worked, and found and returned about 80% of the artists, and around 80% of these again had the conceptually similar artist. What if the alteration could be done in the document itself? For the CSV based script the…

Read More Read More

Useful Research Tools

Useful Research Tools

Writing a paper can be both joy and pain as the writing and editing sessions oscillate between a flow of excellent sentences conveying the propositional content in a clear and gracious way, and word-by-word slow typing sentences which does not feel elegant nor correct nor clear. The tools I have found, and today deeply appreciate, may not help you achieve a perfect state of mind with great ideas, nor a continuous flow of  great words since that is something you…

Read More Read More