Coding frequency and tools

Coding frequency

We asked our respondents, “In my current role, I write code to complete my work objectives _____”.

Show chart Show table
Coding frequency Count
Never 10
Rarely 9
Sometimes 10
Regularly 18
All the time 9
a Sample size = 56

Access to and knowledge of programming languages

For each of the most popular programming languages from last year’s CARS data, we asked respondents to answer “yes”, “no” or “I don’t know” for the following statements:

  • I know how to program with this tool to a level suitable for my work
  • This tool is available to use for my work

Knowledge of programming tools

Show chart Show table
Programming language Yes Don't know No
C++ / C# 18 3 35
Java / Scala 7 3 46
Javascript / Typescript 4 4 48
Python 32 2 22
R 17 4 35
SAS 1 5 50
SPSS 4 5 47
SQL 21 3 32
Stata 4 6 46
VBA 21 3 32
a Sample size = 56

Access to programming tools

Show chart Show table
Programming language Yes Don't know No
C++ / C# 39 14 3
Java / Scala 25 28 3
Javascript / Typescript 19 31 6
Python 51 5 0
R 48 7 1
SAS 4 39 13
SPSS 9 39 8
SQL 35 17 4
Stata 2 43 11
VBA 41 13 2
a Sample size = 56

Access and knowledge gaps

We used the above data to calculate the number of respondents who have access but no knowledge, access and knowledge, and knowledge but no access for each programming language.

Show chart Show table
Programming language Access only Access and knowledge Knowledge only
C++ / C# 23 16 2
Java / Scala 18 7 0
Javascript / Typescript 15 4 0
Python 20 31 1
R 32 16 1
SAS 4 0 1
SPSS 7 2 2
SQL 17 18 3
Stata 2 0 4
VBA 22 19 2
a Sample size = 56

What are people using code for?

We asked respondents what data operations they do in their work, and whether they use code to do them.

Show chart Show table
Data operation I do this without coding I do some or all of this by coding
Data Analysis 7 43
Data Cleaning 5 30
Data Transfer / Migration 15 21
Data Visualisation 7 39
Quality Assurance 20 17
a Sample size = 56

Coding capability

We asked respondents a series of questions about whether they feel their coding ability is improving in their current role and where they first learned to code.

Change in coding ability during current role

Respondents who had coding experience outside of their current role were asked whether there has been a change in their coding ability during current employment.

Show chart Show table
Coding ability changes Count
Significantly worse 3
Slightly worse 10
No change 9
Slightly better 10
Significantly better 14
a Sample size = 46

Where respondents have learned to code

Respondents were asked whether they had coding experience outside their current role and, if so, where.

Show chart Show table
First coding experience Count
In current role 4
In education 29
In private sector employment 2
In public sector employment 0
Self-taught 15
Other 0
a Sample size = 50

Coding practices

We asked respondents to report how often they make use of each of the coding practices. Please note that while there are many different coding practices listed below, we understand that not all are proportionate for every coding project.

General coding practices

Show chart Show table
Percent
Question I don't understand this question Never Rarely Sometimes Regularly All the time
I use open source software when programming 0.0 4.3 10.9 19.6 39.1 26.1
I follow a standard directory structure when programming 6.5 4.3 8.7 32.6 32.6 15.2
I follow coding guidelines or style guides when programming 0.0 4.3 13.0 28.3 30.4 23.9
I use a source code version control system e.g. Git 2.2 15.2 15.2 23.9 17.4 26.1
Code my team writes is reviewed by a colleague 0.0 10.9 28.3 23.9 23.9 13.0
I write repetitive elements in my code as functions 0.0 0.0 4.3 10.9 28.3 56.5
I collect my code and supporting material into packages 4.3 19.6 19.6 13.0 21.7 21.7
I unit test my code 13.0 13.0 13.0 17.4 28.3 15.2
I write code to automatically quality assure data 2.2 32.6 17.4 23.9 13.0 10.9
My team open sources its code 4.3 50.0 17.4 17.4 8.7 2.2
a Sample size = 46

Documentation

Show chart Show table
Percent
Question I don't understand this question Never Rarely Sometimes Regularly All the time
Analytical Quality Assurance (AQA) logs 15.2 45.7 15.2 13.0 4.3 6.5
Data or assumptions registers 2.2 30.4 15.2 13.0 26.1 13.0
Documentation for each function or class 0.0 15.2 8.7 21.7 28.3 26.1
Code comments 0.0 2.2 0.0 2.2 30.4 65.2
Flow charts 0.0 30.4 17.4 32.6 13.0 6.5
README files 0.0 6.5 17.4 19.6 37.0 19.6
Desk notes 26.1 26.1 15.2 17.4 10.9 4.3
a Sample size = 46

Reproducible workflow packages

We asked respondents “do you use reproducible workflow packages e.g. drake, make or pymake?”.

Show chart Show table
Use reproducible workflow packages Count
Yes 12
No 22
Don't know what they are 12
a Sample size = 46

Source control platform

The number of users of each source control platform.

Show chart Show table
Version control platform Yes
GitHub 15
GitLab 4
BitBucket 30
AWS CodeCommit 0
Cloud Source Repository (Google Cloud) 0
a Sample size = 46

RAP knowledge and opinions

Knowledge of RAP and RAP champions

We asked our respondents whether they had heard of RAP and what their knowledge is of their own department RAP champion.

Show chart Show table
RAP champion knowledge Count
Have not heard of RAP 32
Heard of RAP, have not heard of RAP champions 12
Heard of RAP, does not know department champion 4
Heard of RAP champions, no champion in department 0
Knows department RAP champion 7
a Sample size = 56

Opinions on RAP

We asked our respondents who had heard of RAP the extent to which they agree with the following statements:

  • “I understand what the key components of the RAP methodology are”
  • “I feel confident implementing RAP in my work”
  • “I think it is important to implement RAP in my work”
  • “I feel supported to implement RAP in my work”
  • “I know where to find resources to help me implement RAP”
  • “I and/or my team are currently implementing RAP”

The figure and table show the percentage of respondents who picked each response option. Percentages are out of a sample of respondents who said they had heard of RAP.

Show chart Show table
Percent
Question Strongly disagree Disagree Neutral Agree Strongly agree
I understand what the key components of the RAP methodology are 4.2 33.3 4.2 45.8 12.5
I feel confident implementing RAP in my work 4.2 41.7 16.7 33.3 4.2
I think it is important to implement RAP in my work 4.2 8.3 16.7 37.5 33.3
I feel supported to implement RAP in my work 4.2 16.7 33.3 37.5 8.3
I know where to find resources to help me implement RAP 8.3 16.7 33.3 33.3 8.3
I and/or my team are currently implementing RAP 8.3 25.0 29.2 29.2 8.3
a Sample size = 24

RAP scores

RAP components

The frequencies for each RAP component below are derived from a series of questions on coding practices (see the coding practices page). These were used to calculate scores for each component (0/1) where respondents answered “regularly” or “all the time” to the relevant questions. The list of RAP components used here is based on the RAP minimum viable product guidance agreed by the RAP champions network.

Show chart Show table
Component Type Count
Documentation Basic 25
Peer review Basic 17
Team open source code Basic 5
Use open source software Basic 30
Version control Basic 20
Code packages Advanced 20
Continuous integration Advanced 9
Dependency management Advanced 24
Follow code style guidelines Advanced 25
Function documentation Advanced 25
Functions Advanced 39
Unit testing Advanced 20
a Sample size = 46

Basic RAP scores

Show chart Show table
Basic RAP score Count
0 16
1 12
2 10
3 10
4 5
5 3
a Sample size = 46

Advanced RAP scores

Show chart Show table
Advanced RAP score Count
0 3
1 8
2 4
3 8
4 5
5 10
6 4
7 4
a Sample size = 46