Write a python script that will bring two tables "Table 1" and "Table 2" all info from SQL Server and then save it as an excel file with two tabs. Table 1 = tab 1 table 2 = tab 2 Hints: from SQL, you will do query 1 = "select * from table 1" and query 2= "select * from table 2". And all the info save in one excel with two tabs. Please write a python script to do the above task.

As part of this assignment, the program that you will be writing will store current grades in a dictionary using course codes as keys and with values consisting of percent grades in lists. The main functions of this program are to print a student's gradebook, to drop the lowest grade in each course, print the student's gradebook again, drop the course with lowest average, and finally printing the student's gradebook again.  This program requires a main function and a custom value-returning function. In the main function, code these basic steps in this sequence (intermediate steps may be missing): start with an empty dictionary that represents a gradebook and then use a while loop to allow the input of course codes from the keyboard. End the while loop when the user presses enter without entering data.within the while loop:for each course entered, use a list comprehension to generate five random integers in the range of 70 through 100. These random integers in a list represent the…

Create a datafile that contains the first name, last name, gender, age, height, smoking preference, eye color and phone number. Add a variety of records to the file. A sample file looks like:  Write a program that opens the file and reads the records one by one. The program will skip any records where the gender preference is not a match. Of those records that match the gender preference, check to see if the age and height are between the maximum and minum preferences. Then check to see if the smoking preference and eye color are also a match. If at least 3 of the remaining fields match, consider the record a partial match, and print it in the report. If all 4 of the remaining fields match, the record is a perfect match and print it in the report with an asterisk next to it. At the end of the program, close the file and report how many total records there were of the specified gender, how many were a partial match, and how many were a perfect match.

Write a python program that stores current grades in a dictionary, with course codes as keys and percent grades as values. Start with an empty dictionary and then use a while loop to enable input of course codes and percent grades from the keyboard. Enter data for at least five courses. After entering the data, use a for loop and the keys to show the current status of all courses. This same loop should include code that enables determination of the worst course and the average of all courses. Both of these findings should be printed when the loop ends. The worst course should be dropped and reported. This being done, the program should use another loop and the items method to display the revised courses and grades and report the revised term average.

How do I read in a specific row in a CSV file in Python without using pandas, list, or enumerate functions? For example, how do I ask to read row 10 in the file, and then ask for row 50, row 20 or row X?

python

Consider the data contained in the text file data1.txt. The first row of this file contains the column names. The remaining rows have one number for each column. The numbers are separated by a tab character. You can work in your command window. No need to create a matlab file for this question. Download the data file. Use importdata() function to load data into Matlab. What is the average of the numbers contained in the third column of this data?  Data1:  col1 col2 col3 col4 col5 906 552 743 348 45 676 229 425 661 558 469 642 430 384 773 913 485 125 628 312 105 152 25 22 179 746 782 291 911 339 737 101 318 801 211 562 295 654 746 511 185 238 957 814 907 598 531 936 384 629 300 92 458 618 102 135 406 241 576 391 213 105 764 531 55 895 113 760 276 502 72 785 741 249 432 243 292 744 452 998 54 604 106 228 812 442 965 682 805 486 14 433 464 987 895 898 695 213 30 138 197 759 99 536 391 94 433 824 88 928 308 656 176 803 918 457 110 164 990 714 102 934 666 67 619 996 188 895 940 344 333 267…

Assignment 2 will require Array of records (structs) with file I/O is needed. the program will read its data from a text file named coins.txt. There can be 0 and up to 10 input lines, each line is formatted like the example below; Jane 30 cents in AU$ Joe  85 cents in EUR Jane 15 cents in US$ Names are one-word strings. The same name can be repeated in the data file but the coin values/currencies can be different. If the name is the same, your program must assume it relates to the same individual. You are asked to write a program that reads the data from this file. For each individual, the program must add up the coin amounts that belong to the same currency to obtain a total amount for that individual in that currency. It needs to compute the change to be given for that individual for each currency that individual owns. e.g, the example above shows Jane has 30 + 25 = 55 cents in AU$ and 15 cents in US$. The program needs to calculate how many coins (hereinafter referred to as change)…