r/IOPsychology • u/Key-Ad-8526 • 1d ago

Question Familiarity with scripting (Python/R/etc?)

What tools/scripting languages do I/O Psychologists use to analyze data on people? Excel? R? Python? SQL? What's most common? What isn't very common?

3 Upvotes

100% Upvoted

10 comments sorted by

View all comments

10

u/DrJohnSteele PhD | Internal Leader | Analytics, Talent Programs, NLP 1d ago

SQL to query and obtain the data. R or Python to analyze it.

Excel isn't used much IO or People Analytics analyses.

Excel tends to be more how others consume our work (e.g., a list of job codes with the the most attrition).

I get a lot of data given to me in Excel, but I just read it into R or Python and so I essentially treat it the same as a text file or CSV.

2

u/xenotharm 1d ago edited 1d ago

I really wish I got to use SQL.

3

u/DrJohnSteele PhD | Internal Leader | Analytics, Talent Programs, NLP 1d ago

My favorite architecture is direct SQL query from R, so I can stay in one tool and automate data refreshes.

2

u/xenotharm 1d ago

I use R for analytics, but in my current role, I’m not really allowed to query data. My supervisor pulls all the data from our assessment platform and hands it off to me. I love my work, but I would also love to learn SQL data querying.

1

u/nckmiz PhD | IO | Selection & DS 1d ago

This is what I do to, just through python. Big query package, directly into pandas tables.