using the data set from the link: https://www.kaggle.com/osmi/mental-health-in-tech-survey?select=survey.csv Write Python code to return the following data: • Select all rows where the Age is less than 1 • Select all rows where the Age is greater than 99

using the data set from the link: https://www.kaggle.com/osmi/mental-health-in-tech-survey?select=survey.csv Write Python code to return the following data: • Select all rows where the Age is less than 1 • Select all rows where the Age is greater than 99

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter8: Arrays

Section: Chapter Questions

Problem 2MQ2

See similar textbooks

Similar questions

I need help with this code Python: import randomfrom tabulate import tabulate#select the marksgradePoints = {"A":4,"B":3,"C":2,"D":1,"F":0}courseList = ["CST 161","Mat 144","ENG 201","PSY 101","HIS 101"]gradeList = ["A","B","C","D","F"]creditList = [3,4] data = []total_credit = 0sums = 0 #input the number of course that you want to select randomlyn = int(input("Enter the number of courses : "))for i in range(n): temp = [] #for courses k = random.randint(0,4) temp.append(courseList[k]) #for credits k = random.randint(0,1) total_credit += creditList[k] temp.append(creditList[k]) #for grades k = random.randint(0,4) temp.append(gradeList[k]) #for gradepoints sums += gradePoints[gradeList[k]] * temp[1] temp.append(gradePoints[gradeList[k]] * temp[1]) data.append(temp) print(tabulate(data,headers = ["Course","Credits","Grade","Value Per Course"]))print(f"Total credits taken: {total_credit}")print(f"Total quality points earned :…
Looking for this in Python, please. Shopping list assignment (Parallel Array) Create three global variables with the proper data types: sub_totaltotal_pricesales_tax Sales tax is 9.5% Seven items minimum Create a shopping list (List, Tuple or Dictionary) of your choice (Items in list) Create a price list (Price for each item in shopping list) Create and print your parallel array (match each item to its price) Print the list with its index numbers Select one or more items from the shopping list using the index number Print your selected items with price Print sub total (base price of item(s) before tax) Print sales tax amount (before adding it into total price) Calculate and print total price with tax included. (this is what you would pay walking out the door) Round to two decimal points
Cargo Container Report. You will be producing a program which will allow the user to generate the container report on the following page in Container Number order or Ship Name order. The program will also the user to lookup the data for any given Container by number. The % cargo weight is the percentage of the cargo of the gross weight (cargo weight/gross weight), % total is the percentage of the cargo for that container of the total amount of cargo unloaded (cargo weight for the container / total cargo unloaded. Hint: you are expected to use methods for your calculations. The accompanying file has the data for the containers unloaded today. The data includes container number int ship name. String tare weight of the container (empty weight) int the gross weight (container plus the cargo). Int You will need to computer the cargo weight as the gross weight minus the tare weight. If you have issues reading the data with the String, you may remove the String. However, you will lose points.…
A program uses two parallel arrays named customerNumbers and balances. The customerNumbers array holds customer numbers and the balances array hold customer account balances. If a particular customer's customer number is stored in customerNumbers [187], where would that customer's account balance be stored? Edit Format Table
Python program named "YourMuseumID_Exhibits.py" focusing on museum exhibit data: You have a list of dictionaries representing exhibits in a museum. Each dictionary contains the exhibit name, the number of artifacts on display, and the historical era it covers. Perform the following tasks: (a) Calculate and display the total number of artifacts on display for all exhibits in the museum. (b) Identify and display the exhibit with the highest number of artifacts on display. (c) Implement a function that takes a user-input exhibit name and searches for it in the list. If found, display the number of artifacts on display and the historical era it covers; if not found, print a message indicating that the exhibit is not in the museum. (d) Implement a sorting algorithm of your choice to sort the exhibits based on the number of artifacts on display in descending order and display the sorted list. Make sure to incorporate functions for each task and display the results in the main function with…
Python Programming Assignment: Create a dictionary that takes a basketball team's information (that includes team's name and points) as parameter, creates a teams_dict and returns it. Also, create a parameter for write_file parameter that opens current results text file in write mode and writes the dictionary information to file as per format and closes the file.
omplete the python code Find the mean, median, and mode of the column wt. Print the mean, median, and mode Ex: for the column qsec, the output would be: mean = 17.84875, median = 17.710, mode = 0 17.02 1 18.90 dtype: float64 import pandas as pd df = pd.read_csv('mtcars.csv') mean = # find the mean of the column wt median = # find the median of the column wt mode = #find the mode of the column wt print("mean = {:.5f}, median = {:.3f}, mode = {}".format(mean, median, mode))
Python problem Ask the user to enter their company name to validate it based on the database list(COMPANYLIST). If the user enters invalid inputs (which means it is not in the database list), after the second invalid input, your code should show (print) the list of the company names. #company database listCOMPANYLIST = ["Amazon", "Apple", "Facebook", "Google", "Uber"] Ask the user the rate and the hours and validate them to be a numeric and positive value Save the inputs in a dictionary like theDict = { "rate":50, "hours": 120, "compan_name": "Google"} If "hours" is greater than 40, multiply 1.5 by the rate for the overtime print the pay stub Use modules and import them to the main file Your main file can be like this: from getInputsFile import getInputsfrom computePayFile import computePayfrom printPayFile import printPay def payProcess(): ''' This function is to process all other functions to get inputs, calculate and print the pay stub ''' theDict =…
*Reasking a question to make request clearer Looking to code in python the following: Suppose the weekly hours for all employees are stored in a table. Each row records an employee’s seven-day work hours with seven columns. For example, the following table stores the work hours for eight employees. Su M T W Th F Sa Employee 0 2 4 3 4 5 8 8 Employee 1 7 3 4 3 3 4 4 Employee 2 3 3 4 3 3 2 2 Employee 3 9 3 4 7 3 4 1 Employee 4 3 5 4 3 6 3 8 Employee 5 3 4 4 6 3 4 4 Employee 6 3 7 4 8 3 8 4 Employee 7 6 3 5 9 2 7 9 I need a program that inputs the hours of all employees by the user and displays employees and their total hours in decreasing order of the total hours. Thanks
In Python, grades_dict = {'Wally': [87,96,70], 'Eva': [100,87,90], 'Sam': [94,77,90], 'Katie': [100,81,82], 'Bob': [83, 65, 85]} Ask user to enter the names of the rows, i.e., indices. You can use: len(grades) to get the number of rows of the DataFrame. In addition, using the sort_index() method, ask user whether they wish to sort by rows or by columns and whether to sort in ascending or descending order (do not use any if-else statements)
Write a PHP code to: Create the following two dimensional array $students: ID Name Score 100 Ali 76 200 Khaleed 33 300 Fatema 89 400 Sumaya 45 Write the function nbFail($list) that takes a multidimensional array $list as parameter and returns the number of failed students (student fails if the score is less than 50). Write the required PHP code to display the array $students in an HTML table (using foreach statement) and the number of failed students and passed students (use the function defined in question b).
In cell C18 type a VLOOKUP function to find the corresponding letter grade (from column D) for the name in A18. The table array parameter is the same as in B18. Type FALSE for the range lookup parameter. Copy the formula in C18 to C19:C22Notice this formula works correctly for all cells. Range lookup of FALSE means do an exact match on the lookup value whether or not the table array is sorted by its first column. In cell E11, type an IF function that compares the score in B11 with the minimum score to pass in A5. If the comparison value is true, display Pass. Otherwise, display Fail. Copy the formula in E11 to E12:E15. Did you use appropriate absolute and relative references so the formula copied properly? In cell F11, type an IF function that compares the grade in D11 with the letter F (type F). If these two are not equal, display Pass. Otherwise, display Fail. Copy the formula in F11 to F12:F15