Data pivoting

Author
Affiliation

Lars Schöbitz

ETH Zurich

Reduced level of detail

As we progress through the course, we’re gradually reducing the level of instructional detail. This assignment follows the same steps as earlier modules. If you need detailed guidance, refer back to previous assignments.

Step 1: Clone your module 7 assignments repository

  1. Open https://github.com/ in your browser.
  2. Navigate to the GitHub organization for the course: https://github.com/ds4owd-002
  3. Find the repository md-07-assignments-USERNAME that ends with your GitHub username, and open it by clicking on the repository name.
    • Replace USERNAME with your actual GitHub username.
  4. Click on the green Code button.
  5. Copy the HTTPS URL to your clipboard by clicking on the clipboard icon next to the URL.
  6. Open the Content tab of the ds4owd-002 workspace on Posit Cloud: https://posit.cloud/spaces/663318/content/all?sort=name_asc
  7. Click the blue button New Project > New Project from Git Repository
  8. Paste the HTTPS URL from GitHub into the URL of your Git Repository field and click OK. Leave the checkbox under Packages checked.
  9. Wait until the project is deployed. This may take a few minutes, depending on your internet connection.
  10. Open md-07a-pivoting.qmd and follow the instructions to work through the tasks.

Step 2: Commit and push your changes

  1. Navigate to the Git pane in the top-right window of RStudio
  2. Check the box next to all files to stage them for a commit
  3. Click on the Commit button. A new window opens.
  4. Enter a commit message in the Commit message field in the top right corner. For example: completed pivoting assignment
  5. Click on the Commit button
  6. If you see a message that confirms your commit, click on Close. If you do not see this message, make sure you have staged the files (checked the box next to them) for commit and entered a commit message.
  7. Click on the Push button in the top right corner.
  8. Enter your GitHub username and click OK
  9. Enter your GitHub Personal Access Token (PAT) in the field and click OK. This is the personal access token you created in Module 1.

If you see a message that says HEAD -> main, then you have successfully pushed your changes to the remote repository on GitHub. Click Close. If you do not see this message, make sure you have entered your GitHub username and GitHub PAT correctly.

PAT Storage Warning

If you have stored your PAT in a Word file, a blank space might have been copied along with the PAT. We recommend using a TXT file (Notepad on Windows or TextEdit on Mac) or a password manager to store your PAT securely.

Do not use your GitHub password

You need to enter the GitHub Personal Access Token (PAT) you created in Module 1 to push your changes back to GitHub.

Step 3: Open an issue on GitHub

  1. Open https://github.com/ in your browser.
  2. Navigate to the GitHub organization for the course: https://github.com/ds4owd-002
  3. Find the repository md-07-assignments-USERNAME that ends with your GitHub username, and open it by clicking on the repository name.
    • Replace USERNAME with your actual GitHub username.
Tip

You can search for your repository by typing your username in the search bar just below the Repository heading.

  1. You can verify here that your changes have been pushed to the remote repository by looking at the text next to the md-07a-pivoting.qmd file. It should display the commit message you entered in the previous step.
  2. Click on the Issues tab.
  3. Click on the green New issue button.
  4. In the Title field write: Completed module 7 pivoting assignment.
  5. In the Leave a comment field, tag the course instructors @seawaR @massarin @larnsce
  6. Scroll down the page and click the green Create button.

Congratulations! You have completed the data pivoting assignment.