Coder Social home page Coder Social logo

Comments (2)

francisbarton avatar francisbarton commented on June 21, 2024 1

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.

francisbarton avatar francisbarton commented on June 21, 2024

OK I think I have made a couple of steps forward in understanding the process.

  1. 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 photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.