Responding to CARS is voluntary. The results presented here are from a self-selecting sample of government analysts. Because respondents are self-selecting, the results we present reflect the views of the analysts who participated.
For more detail, see the data collection page.
We asked respondents “In your current role, how often do you write code to complete your work objectives?”
| Coding frequency | Percent |
|---|---|
| Never | 31.9% |
| Rarely | 20.7% |
| Sometimes | 15.9% |
| Regularly | 19.8% |
| All the time | 11.6% |
| Sample size = 232 |
Given a list of programming tools, we asked all respondents if the tool was available to use for their work.
Access to tools does not necessarily refer to official policy. Some analysts may have access to tools others cannot access within the same organisation.
| Programming tool | Yes | No | Don't Know |
|---|---|---|---|
| Python | 71.1% | 6.9% | 22% |
| R | 91.4% | 3.4% | 5.2% |
| SQL | 43.1% | 9.9% | 47% |
| Matlab | 4.3% | 23.7% | 72% |
| SAS | 24.1% | 28% | 47.8% |
| SPSS | 52.2% | 22% | 25.9% |
| Stata | 15.5% | 24.6% | 59.9% |
| VBA | 16.4% | 17.2% | 66.4% |
| Sample size = 232 |
Given the same list of programming tools, all respondents were asked if they knew how to program with the tool to a level suitable for their work, answering “Yes”, “No” or “Not required for my work”.
Please note that capability in programming languages is self-reported here and was not objectively defined or tested. The statement “not required for my work” was similarly not defined.
| Programming tool | Yes | No | Not required for my work |
|---|---|---|---|
| Python | 23.7% | 41.8% | 34.5% |
| R | 41.4% | 36.6% | 22% |
| SQL | 19% | 36.6% | 44.4% |
| Matlab | 0.9% | 34.5% | 64.7% |
| SAS | 12.5% | 33.2% | 54.3% |
| SPSS | 40.5% | 21.6% | 37.9% |
| Stata | 9.5% | 31.5% | 59.1% |
| VBA | 3.4% | 33.6% | 62.9% |
| Sample size = 232 |
We asked respondents to answer “Yes”, “No” or “Don’t know” for the following questions:
Please note these outputs include people who do not code at work.
Respondents with coding experience outside their current role were asked where they first learned to code. Those analysts who code in their current role but reported no other coding experience, are included as having learned ‘In current role’. Those who reported first learning to code outside of a work or educational environment were categorised as ‘self-taught’ based on free-text responses.
These data only show where people first learned to code. They do not show all the settings in which they had learned to code, to what extent, or how long ago.
| Where learned | Percent |
|---|---|
| Current employment | 44.9% |
| Education | 39.2% |
| Previous private sector employment | 3.2% |
| Previous public sector employment | 8.9% |
| Self-taught | 2.5% |
| Other | 1.3% |
| Sample size = 158 |
We asked “Has your coding ability changed during your current role?”
This question was only asked of respondents with coding experience outside of their current role. This means analysts who first learned to code in their current role are not included in the data.
| Ability change | Percent |
|---|---|
| Significantly worse | 10.3% |
| Slightly worse | 10.3% |
| Stayed the same | 16.1% |
| Slightly better | 29.9% |
| Significantly better | 33.3% |
| Sample size = 87 |
We asked respondents who said they currently use code in their work, how often they carry out various coding practices. For more information on the practices presented below, please read our guidance on Quality Assurance of Code for Analysis and Research
Open sourcing was defined as ‘making code freely available to be modified and redistributed’
| Statement | I don't understand this question (%) | Never (%) | Rarely (%) | Sometimes (%) | Regularly (%) | All the time (%) |
|---|---|---|---|---|---|---|
| Automated data quality assurance | 8.9% | 36.1% | 14.6% | 23.4% | 12% | 5.1% |
| Code review | 2.5% | 9.5% | 9.5% | 26.6% | 29.7% | 22.2% |
| Coding guidelines / Style guides | 10.1% | 12.7% | 13.9% | 25.3% | 29.7% | 8.2% |
| Functions | 11.4% | 15.8% | 16.5% | 27.2% | 22.8% | 6.3% |
| Open source own code | 30.4% | 43% | 9.5% | 8.9% | 5.1% | 3.2% |
| Packaging code | 21.5% | 57% | 13.3% | 4.4% | 3.2% | 0.6% |
| Proportionate quality assurance | 15.8% | 11.4% | 5.7% | 10.8% | 33.5% | 22.8% |
| Quality assurance throughout development | 10.1% | 13.9% | 5.7% | 19% | 32.9% | 18.4% |
| Standard directory structure | 35.4% | 20.9% | 9.5% | 13.9% | 12% | 8.2% |
| Unit testing | 38% | 29.7% | 12% | 8.2% | 9.5% | 2.5% |
| Use open source software | 5.7% | 7% | 14.6% | 17.7% | 25.9% | 29.1% |
| Version control | 11.4% | 28.5% | 12.7% | 19.6% | 16.5% | 11.4% |
| Sample size = 158 |
We asked respondents who reported writing code at work how frequently they write different forms of documentation when programming in their current role.
Embedded documentation is one of the components which make up a RAP minimum viable product. Documentation is important to help others be clear on how to use the product and what the code is intended to do.
| Statement | I don't understand this question (%) | Never (%) | Rarely (%) | Sometimes (%) | Regularly (%) | All the time (%) |
|---|---|---|---|---|---|---|
| Analytical Quality Assurance (AQA) logs | 30.4% | 38% | 7% | 12.7% | 7.6% | 4.4% |
| Code comments | 6.3% | 9.5% | 4.4% | 8.2% | 27.2% | 44.3% |
| Data or assumptions registers | 25.3% | 35.4% | 5.1% | 12% | 12% | 10.1% |
| Desk notes | 17.1% | 25.9% | 10.1% | 22.8% | 15.2% | 8.9% |
| Documentation for each function or class | 19% | 34.2% | 15.8% | 13.9% | 10.8% | 6.3% |
| Flow charts | 12.7% | 42.4% | 12% | 19% | 10.8% | 3.2% |
| README files | 13.9% | 40.5% | 13.3% | 19% | 8.9% | 4.4% |
| Sample size = 158 |
We asked respondents who reported writing code at work if they manage dependencies for their projects.
We provided examples of tools that may be used for dependency management:
| Use dependency management software | Percent |
|---|---|
| Yes | 10.1% |
| No | 27.8% |
| I don't know what dependency management is | 62% |
| Sample size = 158 |
We asked respondents who reported writing code at work if they use continuous integration.
We provided some examples of continuous integration technologies:
| Use continuous integration | Percent |
|---|---|
| Yes | 13.3% |
| No | 30.4% |
| I don't know what continuous integration is | 56.3% |
| Sample size = 158 |
We asked respondents who reported writing code at work whether they use reproducible workflow packages.
We provided some examples of packages:
| Use reproducible workflow packages | Percent |
|---|---|
| Yes | 3.8% |
| No | 41.8% |
| I don't know what reproducible workflows are | 54.4% |
| Sample size = 158 |
We asked respondents about their knowledge of and opinions on reproducible analytical pipelines (RAP). RAP refers to the use of practices from software engineering to make analysis more reproducible. These practices build on the advantages of writing analysis as code by ensuring increased quality, trust, efficiency, business continuity and knowledge management.
The RAP champions are a network of analysts across government who promote and support RAP development in their departments. Please contact the analysis standards and pipelines team for any enquiries about RAP or the champions network.
The Analysis Function RAP strategy was released in June 2022 and sets out plans for adopting RAP across government.
We asked respondents who reported writing code at work, if they had heard of RAP.
We asked respondents who had heard of RAP, if their department has a RAP champion and if they know who it is.
| Knowledge | Percent |
|---|---|
| Yes, and I am a RAP Champion | 0.7% |
| Yes, and I know who the RAP Champion is | 18.7% |
| Yes, but I don't know who the RAP Champion is | 22.3% |
| No | 2.9% |
| I don't know | 55.4% |
| Sample size = 139 |
We asked respondents who had heard of RAP, if they had heard of the RAP strategy.
| RAP strategy knowledge | Percent |
|---|---|
| Yes | 23.7% |
| Yes, but I haven't read it | 37.4% |
| No | 38.8% |
| Sample size = 139 |
We asked respondents who had heard of RAP whether they agreed with a series of statements.
| Statement | Strongly Disagree (%) | Disagree (%) | Neutral (%) | Agree (%) | Strongly Agree (%) |
|---|---|---|---|---|---|
| I and/or my team are currently implementing RAP | 18% | 28.8% | 25.2% | 19.4% | 8.6% |
| I feel confident implementing RAP in my work | 15.1% | 30.9% | 26.6% | 22.3% | 5% |
| I feel supported to implement RAP in my work | 14.4% | 15.1% | 33.1% | 30.9% | 6.5% |
| I know where to find resources to help me implement RAP | 14.4% | 18.7% | 19.4% | 41% | 6.5% |
| I or my team are planning on implementing RAP in the next 12 months | 10.8% | 17.3% | 27.3% | 31.7% | 12.9% |
| I think it is important to implement RAP in my work | 2.9% | 6.5% | 24.5% | 39.6% | 26.6% |
| I understand what the key components of the RAP methodology are | 11.5% | 25.9% | 17.3% | 38.8% | 6.5% |
| Sample size = 139 |
In this section we present RAP components and RAP scores.
For each RAP component a percent positive was calculated. Positive responses were recorded where an answer of “regularly” or “all the time” was given. For documentation, a positive response was recorded if both code comments and README files questions received positive responses. For the continuous integration and dependency management components, responses of “yes” were recorded as positive.
“Basic” components are the components which make up the RAP MVP. “Advanced” components are components which help improve reproducibility, but are not considered part of the minimum standard.
| RAP component | Type | Percentage of analysts who code in their work |
|---|---|---|
| Proportionate QA | Basic | 56.3% |
| Use open source software | Basic | 55.1% |
| Peer review | Basic | 51.9% |
| Version control | Basic | 27.8% |
| Documentation | Basic | 12.7% |
| Team open source code | Basic | 8.2% |
| Follow code style guidelines | Advanced | 38% |
| Functions | Advanced | 29.1% |
| Function documentation | Advanced | 17.1% |
| Continuous integration | Advanced | 13.3% |
| Unit testing | Advanced | 12% |
| Dependency management | Advanced | 10.1% |
| Code packages | Advanced | 3.8% |
| Sample size = 158 |