quiz_PYW1 Download

5 upvotes
Visit on GitHub
Preview Quiz.md
  1. Create a new column in the DataFrame and name it Total Sales. This column is a sum of Consulting Sales and Software Sales. Use head or tail to peek at the resulting data frame to confirm that the output matches your expectation. What is the sum of the Total Sales column?

    • [ ] 11,470,000
    • [ ] 19,238,903
    • [ ] 7,768,903
  2. Which company has the biggest Total Sales in 2017?

    • [ ] New Media Group
    • [ ] PT. Algoritma Data Indonesia
    • [ ] Palembang Konsultansi
  3. Which are the two companies that has sales exceeding 1,500,000 IDR in the sampled data frame?

    • [ ] Palembang Konsultansi & PT. Surya Citra Manajemen
    • [ ] PT. Surya Citra Manajemen & New Media Group
    • [ ] Palembang Konsultansi & New Media Group
  4. The simplest way to ignore the outliers of sample data and find its central value is by using median instead of mean. By ignoring the outliers of Total Sales, what is its central value?

    • [ ] 1,354,250
    • [ ] 1,515,875
    • [ ] 3,737,700
  5. If we want to perform subsetting on clients by explicitly stating the ID, which subsetting method is more appropriate?

    • [ ] clients.loc[57531, : ]
    • [ ] clients.iloc[57531, : ]
    • [ ] clients[57531, : ]
  6. Say, we need to find clients of Enterprise account which specifically located in Jakarta. Try to fill in the blank codes to perform the right conditional subsetting: clients[________ _ ________]:

    • [ ] (clients.Location == "Jakarta"), |, (clients.Account == "Enterprise")
    • [ ] clients.Location == "Jakarta", &, clients.Account == "Enterprise"
    • [ ] (clients.Location == "Jakarta"), &, (clients.Account == "Enterprise")
    • [ ] clients.Location == "Jakarta", |, clients.Account == "Enterprise"
Quiz
You need to score 4 out of a possible 6 to earn a badge.
You have 2 attempts. Only your highest score will be taken into account.
  • Quiz 1

    Create a new column in the DataFrame and name it Total Sales. This column is a sum of Consulting Sales and Software Sales. Use head or tail to peek at the resulting data frame to confirm that the output matches your expectation. What is the sum of the Total Sales column?

    Question worth 1 point

  • Quiz 2

    Which company has the biggest Total Sales in 2017?

    Question worth 1 point

  • Quiz 3

    Which are the two companies that has sales exceeding 1,500,000 IDR in the sampled data frame?

    Question worth 1 point

  • Quiz 4

    The simplest way to ignore the outliers of sample data and find its central value is by using median instead of mean. By ignoring the outliers of Total Sales, what is its central value?

    Question worth 1 point

  • Quiz 5

    If we want to perform subsetting on clients by explicitly stating the ID, which subsetting method is more appropriate?

    Question worth 1 point

  • Quiz 6

    Say, we need to find clients of Enterprise account which specifically located in Jakarta. Try to fill in the blank codes to perform the right conditional subsetting: clients[________ _ ________]:

    Question worth 1 point

Recipients 170

Users with passing score on quiz_PYW1