1
$\begingroup$

At work, I am in a role that does not have a lot of computer permissions. I do have the Microsoft office suite. I have skills with programming and would like to be able to use my experience to do more streamlined and substantial manipulation of large relational data sets. Considering I can't get python or even Bash, is there any good way to do this?

| improve this question | | | | |
$\endgroup$
  • 1
    $\begingroup$ If you have Excel, you have access to write VBA scripts $\endgroup$ – Jon Feb 2 '18 at 0:05
  • $\begingroup$ You can write SQL in Access $\endgroup$ – David Marx Feb 2 '18 at 0:11
  • $\begingroup$ Have you tried power query using the data model in Excel $\endgroup$ – grldsndrs Feb 2 '18 at 7:44
1
$\begingroup$

It should be possible to install Python without admin privileges. This has been discussed on Stackoverflow here.

The easiest method appears to be installing Anaconda.

And according to this answer you should also be able to use WSL without admin rights, which will get you bash.

For handling relational data you can use sqlite, which is built-in to Python. For example:

import sqlite3

conn = sqlite3.connect('example.db')
cur = conn.cursor()
cur.execute('''CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT''')
conn.commit()
conn.close()
| improve this answer | | | | |
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.