codebook | Reference material for ACM-ICPC

I have a data.farme that looks like this:

I want to generate a new df as codebook where the numbers in col Label will be replaced using the information from ID and Subject.

what should I do?

The codebook file that I want to achieve is sth that looks like this:

Sample data can be build using codes:

I am reading a set of sas data into r. I wonder whether there is a code that I use to get the variable name and variable label into a data.frame, or sth like a codebook?

I used haven package to read in data

I recently learned about the {codebook} and {labelled} packages for annotating datasets. This codebook tutorial demonstrates an interesting approach for using a built-in function to label all variables at once from a separate meta data table.

I don't see a similar approach for assigning value labels, but I think it should be possible.

Here's a toy dataset (df) with a separate dataframe of meta data (meta):

I am trying to download an excel file for which I am giving the proper path. But after downloading it when I am trying to open I get error as

excel cannot open the file because the file format or file extension is not valid. Verify that file has been corrupted...

in this apart class I created the exporting function to create and write the data in an excel file

I am trying to create a codebook-style environment in an Rmarkdown document, as shown below:

These are my data:

These are my data frames:

Apologies if the answer is something simple but I'm a bit new to this.

Essentially I have two tables.

1) This table details a persons biographic details with the following columns.

Forename | Surname | DOB - Day | DOB - Month | Dob Year

2) This table is a reference table called "codebook" its used as a lookup and has the following columns

Key | Value

In the first table, both the "DOB - Day" and "DOB - Month" reference the "codebook table" (this is because these two columns are actually combo boxes within an applications so the values that are stored here reference the codebook table)

My problem is when I'm trying to query the database - essentially I want the results that are displayed to the user to show the actual values for the "DOB - Day" and "DOB - Month" column's rather than the ID that's actually stored in the first table.

I'll add some simple data to both tables for context.

Table 1

I got the random password generator program from here https://codereview.stackexchange.com/questions/138703/simple-random-password-generator And then I wanted to make a simple password program. Which generate 3 random char and uses sprint to combine "REG-" with the 3 random char.