(10pt) Question 1. (A and B are necessary)
A valid email contains the @ symbol in a string, with user’s name and domain name.
(A). Import email.txt and implement checking to recognize all invalid email addresses and export them to
invalid.txt
(B). Continue with (A). When you register an account, the account should have at least 6 characters.
Therefore, a valid email address should satisfy two requirements (1) the user's name is longer than or
equal to 6 and (2) with a symbol @. Please implement a refined email checker to recognize all invalid
email addresses and export them to a refined_invalid.txt
(10pt) Question 2. (A, B and C are necessary)
Descriptive analysis of data is essential for business analytics.
(A). Load and read the file "stock2020.xlsx".
(B). Compute the descriptive statistics (i.e., mean, std, min, max, median, Q25 and Q75 ) for
each stock in "stock2020.xlsx".
(C). Export the descriptive statistics of every stock to its csv files (e.g., AAPL.csv, BA.csv, FB.csv,
etc.).