Comments (2)
For anyone finding this issue: you can see what I did in the end, to work out how to achieve this, here.
NB that code draws on other functions (see the source
line at the top) which use this dwpstat
package to interface with StatXplore; it also draws on its context within that package, for example pulling in a vector of LSOA codes from a separate table. It was good to discover the standard ONS LSOA codes work in a StatXplore query, though.
I'd welcome comments or pull requests on my script as I am sure there are things I am missing that would make it more streamlined.
from dwpstat.
OK I think I have made a couple of steps forward in understanding the process.
- I was looking at the list of all national LSOAs and was wondering how to filter it down by LA code.
But, as I already have a list of the LSOA11CD codes for all LSOAs in the area, all I need actually is the code stem (str:valueset:UC_Monthly:V_F_UC_CASELOAD_FULL:COA_CODE:V_C_MASTERGEOG11_LSOA_TO_MSOA
) and then I can easily create a new vector for all the codes based on the vector of LSOA codes. Then I need to include that in the query.
Oli Hawkins' package shows what a query looks like so I just have to work out how to embed my vector into the recodes section of the query within this package's idiom.
The same with the dates that I want (I don't need all 49 months).
from dwpstat.
Related Issues (3)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dwpstat.