Ask a New Question
Search
Questions and answers by
Ccolloh
Questions (28)
Which contestant(s) played a perfect game? A perfect game is considered when the contestant:
didn't receive any tribal council
1 answer
179 views
Which contestant(s) played a perfect game? A perfect game is considered when the contestant:
didn't receive any tribal council
1 answer
119 views
Q9A & Q9B: Now that we know the percentages of total players that are extroverted and introverted, let's see if that made a
1 answer
134 views
Q8A & Q8B: Using the castaway_details data, what is the percentage of total extroverts and introverts that have played the game
1 answer
215 views
# import data from Excel
# setup Filename and Object fileName = "survivor.xlsx" xls = pd.ExcelFile(fileName) # import individual
0 answers
109 views
Q9A & Q9B: Now that we know the percentages of total players that are extroverted and introverted, let's see if that made a
1 answer
131 views
Q8A & Q8B: Using the castaway_details data, what is the percentage of total extroverts and introverts that have played the game
1 answer
97 views
Create a calculated field called Total Payments to Loans
This field represents the proportion of total payments received compared
9 answers
208 views
Create a calculated field called DTI
○ This field represents the debt-to-income ratio. You will calculate it by taking the
3 answers
161 views
Note 2: Also be careful and check your data types for these two fields.
Both fields should be a decimal data type. in tableau
1 answer
108 views
Create a calculated field called Total Annual Income
○ This field represents the addition of the Annual Income variable and the
28 answers
217 views
Q9A & Q9B: Now that we know the percentages of total players that are extroverted and introverted, let's see if that made a
1 answer
189 views
Q19: Which contestant(s) played a perfect game? A perfect game is considered when the contestant:
didn't receive any tribal
1 answer
399 views
For the castaway_details DataFrame, there is a full_name column and a short_name column. It would be helpful for future analysis
1 answer
187 views
Let's see how many winners ended up getting unanimous jury votes to win the game. Create a Dataframe that shows the survivors
1 answer
296 views
What contestant has won the most number of challenges? Select their row from the castaway_details DataFrame and save this as
1 answer
507 views
Q10: Which contestants have never received a tribal council vote (i.e. a vote to be voted out of the game as shown in the
1 answer
555 views
castaway_id full_name total_days_played
0 55 Rob Mariano 131 1 197 Parvati Shallow 130 2 201 Oscar Lusth 128 3 179 Cirie Fields
1 answer
205 views
Who played the most total number of days of Survivor? If a contestant appeared on more than one season, you would add their
1 answer
291 views
Q17:
Create a function called sets_from_minifig that takes as input a minifig number (as a string) and returns a list of sets a
1 answer
282 views
Q13:
How many minifigs are contained in the set from the Millennium Falcon Prep Exercise? Save this as Q13 (as an integer). Note
1 answer
634 views
Q13:
How many minifigs are contained in the set from the Millennium Falcon Prep Exercise? Save this as Q13 (as an integer). Note
1 answer
488 views
Q9A & Q9B: Now that we know the percentages of total players that are extroverted and introverted, let's see if that made a
1 answer
339 views
Q9A & Q9B: Now that we know the percentages of total players that are extroverted and introverted, let's see if that made a
1 answer
277 views
Q18:
Note: Before you begin working on this question, please note that CodeGrade has a 1GB RAM limit. If you see an Exit -9 code
1 answer
168 views
**Q17:**
- Create a function called `sets_from_minifig` that takes as input a minifig number (as a string) and returns a list of
1 answer
315 views
Q17:
Create a function called sets_from_minifig that takes as input a minifig number (as a string) and returns a list of sets a
1 answer
201 views
**Q16:**
- Create a function called `minifigs_from_themes` that takes as input a theme id (as an integer) and outputs all the
1 answer
251 views
Answers (21)
Q8A & Q8B: Using the castaway_details data, what is the percentage of total extroverts and introverts that have played the game (count players only once even if they have played in more than one season). Do not count contestants without a personality type
Create a calculated field called Payments to Loans Categories If the Total Payments to Loans is less than 15%, then call it Less than 15% If the Total Payments to Loans is greater than or equal to 15%, then call it 15% or Greater in tableau kindly correct
Build a horizontal bar chart that shows the total Loan Amount for each Loan Purpose. Filter the DTI Level for only Medium and High values. Sort the Loan Purpose axis by Loan Amount in descending order Color the chart based on the Payments to Loans
Create a calculated field called Payments to Loans Categories If the Total Payments to Loans is less than 15%, then call it Less than 15% If the Total Payments to Loans is greater than or equal to 15%, then call it 15% or Greater
in tableau
Create a calculated field called Total Payments to Loans This field represents the proportion of total payments received compared to the total loan amount. This should be calculated by the sum of the Paid Total variable divided by the sum of the Loan
Finally, we want to view the total loan amounts broken down by their loan purpose for only the Medium and High DTI Level customers. In addition, we want to see the percentage of total payments received for the respective loan purpose category compared to
Finally, we want to view the total loan amounts broken down by their loan purpose for only the Medium and High DTI Level customers. In addition, we want to see the percentage of total payments received for the respective loan purpose category compared to
Low, Medium, High. appear twice
To add a checkbox in front of each level in the text table, you can make use of the "Show Header" feature in Tableau. Here's how you can do it:
a box infront of the categories
Using the DTI Level calculated field that you created above, create a text table that shows the counts of each range. 7. Build a text table that lists each DTI Level along with the respective counts. ○ Sort the text table rows in this order: Low, Medium,
Create a calculated field called DTI Level ○ If the DTI is less than or equal to 35, then call it Low ○ If the DTI is greater than 35 and less than 50, then call it Medium ○ If the DTI is greater than or equal to 50, then call it High
am clicking on x axis bit not showing edit option
how to edit a bin axis
whats the x-axis label
why is the histogram a single bar
Build a distribution plot (histogram) for Total Annual Income ○ Change bin size to 25,000 ○ The x-axis tick-mark interval should be 25,000 ○ Change the title to Total Annual Income Distribution:
Create a calculated field called DTI ○ This field represents the debt-to-income ratio. You will calculate it by taking the Total Debt variable and dividing it by Total Annual Income calculated in the previous step. We want a percentage, so in the
in tableau
Why are we not using sum of annual income?
