Global AI and Data Science

 View Only

  • 1.  Recoding a variable with multiple values

    Posted Thu July 25, 2024 02:54 PM

    Hi,

    I need some help to recode a string variable with multiple values.

    I have a postcode variable where respondents entered their postcodes as text. Some postcodes are repeated, while others are identical but written differently. The list of postcode responses is extensive, and I want to group them into 5 categories. How can I recode these multiple postcode values into 5 distinct categories?

    Any help would be greatly appreciated.

    Best,

    Mina



    ------------------------------
    Mina
    ------------------------------

    #AIandDSSkills


  • 2.  RE: Recoding a variable with multiple values

    Posted Thu August 01, 2024 12:31 PM

    Hi Mina,

    Could you please ask your question in the product community that is associated with your question. You will get a faster response. Is your question related to SPSS? 

    Thanks,

    Nick

    AI Community Manager



    ------------------------------
    Nick Plowden
    AI Community Engagement
    IBM
    ------------------------------

    Original Message


  • 3.  RE: Recoding a variable with multiple values

    Posted Fri August 02, 2024 05:32 PM

    Hi Mina,

    Just wondering if AUTORECODE would help? or alternatively, you could use CHAR.SUBSTR to split the postcodes into multiple, shorter strings, and recode these?

    Roger



    ------------------------------
    Roger Fiedler
    ------------------------------

    Original Message


  • 4.  RE: Recoding a variable with multiple values

    Posted Fri February 14, 2025 11:14 AM

    ou can recode a variable with multiple values by grouping similar responses into categories. First, identify patterns in the data and standardize inconsistent values (e.g., removing spaces or formatting differences). Then, assign each group to a specific category using a lookup table or conditional statements. This method ensures cleaner data and simplifies analysis. Most statistical tools like SPSS, R, and Python support this process efficiently.



    ------------------------------
    Steve Smith
    ------------------------------

    Original Message