Write code for a function that takes a list of names and ano…
Write code for a function that takes a list of names and another same size list of ints. The function create a plot object where the type of plot is dot plot, where the names represent the x-axis and the ints represent the y-axis. The function returns the plot object without saving or showing it. Add any code needed to use a plotting library or package.
Read DetailsIn the previous function, you pass a filename to a function;…
In the previous function, you pass a filename to a function; in this question you write that function. It will open the file to read its content. You are not allowed to import any package or library for this. Assume the data in a text file (text not CSV), looks like this (i.e. data on a line is separated by a comma): Row, Email, Name, Phone number Where Row is the key and the values are the rest of the row data as a list. Apply regex filter to check for valid emails and US phone numbers (US phone numbers are in the format xxx xxx xxxx). If an email is invalid, skip the entry. If the phone number is invalid, use the entry “invalid phone” instead but process the entry. Return the dictionary at the end.
Read DetailsNow we process the dictionary and add its content to a sqlit…
Now we process the dictionary and add its content to a sqlite3 database. Write a function to receive a dictionary, then perform the following: Connect to a sqlite3 file named Cool to do the rest of the items below. A table named tableP already exists where each record is represented by an alphanumeric values, p1 p2 p3 and p3. Add each dictionary entry to the table using a sql command as follows: Use a for loop to add an entry to the table only if the email ends with .edu When done print the number of all rows that were aded using a SQL command (count). Without using an if statement, if any of the code in this function causes any type of error, return a false value. If all the records are added correctly, print the total number of changes made using a sqlite3 python function. Return a true value. Ensure to apply all the changes and close all open connections.
Read Details