Activity A:

Create a file in Excel and name it IrisSubset1.xlsx as depicted below.

1. Save it as IrisSubset1.csv.
2. Open this saved Excel file (IrisSubset.xlsx) and now save it as IridSubset.csv.
3. Open Spyder or any other python IDE.
4. Modify the code snippet cleanData1.py and apply the technique you have learned now to cleanse the IrisSubset1.csv.
5. Save your modified Python code as cleanData3.py.

Enclose your Python code and screenshot of resulting output.

Activity B:

1. Open your favorite Python IDE.
2. Modify the AIdataPrep1.py file given to you.
3. Modify the Python code changing the Binarization threshold from 0.5 to 1.5.
4. Save your modified code as AIdataPrep2.py.
5. Enclose your Code output and explain your findings.

• Include a screenshot of your output and Python code For Activity A with date in the comments.
• Include a screenshot of your output and Python code For Activity B with date in the comments.

I dont have Excel or Office

can screenshots of the output and code be provided Thank you

\begin{tabular}{|c|c|c|c|c|c|} \hline F2 & & xr & fx & & \\ \hline & A & B & C & D & E \\ \hline 1 & sepal_length & sepal_width & petal_length & & \\ \hline 2 & 5.1 & 3.5 & 1.4 & & \\ \hline 3 & 4.6 & NaN & 1.5 & & \\ \hline 4 & 4.7 & 3.2 & 1.3 & & \\ \hline 5 & 4.9 & 3.9 & 1.3 & & \\ \hline 6 & 5 & NaN & 1.4 & & \\ \hline 7 & 5.1 & 3.5 & 1.4 & & \\ \hline 8 & & & & & \\ \hline \end{tabular}