All the instructions are on the attached zip file. Final document has to be submitted on a Jupyter Notebook file

homework-data-cleaning-files-ugf44p3y/__MACOSX/._Homework - Data cleaning - files
homework-data-cleaning-files-ugf44p3y/__MACOSX/Homework - Data cleaning - files/._.DS_Store
homework-data-cleaning-files-ugf44p3y/__MACOSX/Homework - Data cleaning - files/._Instructions.rtf
homework-data-cleaning-files-ugf44p3y/__MACOSX/Homework - Data cleaning - files/._sales test.csv
homework-data-cleaning-files-ugf44p3y/__MACOSX/Homework - Data cleaning - files/._SKU master test.csv
homework-data-cleaning-files-ugf44p3y/__MACOSX/Homework - Data cleaning - files/._transfers test.txt
homework-data-cleaning-files-ugf44p3y/Homework - Data cleaning - files/.DS_Store
homework-data-cleaning-files-ugf44p3y/Homework - Data cleaning - files/.ipynb_checkpoints/Data cleaning homework solution-checkpoint.ipyn
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Data cleaning homework solution"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Import some basic packages"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import sys, pandas as pd, matplotlib as mpl, matplotlib.pyplot as plt, numpy as np"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
" Now let's load our data from the files"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [],
"source": [
"s=pd.read_csv('sales test.csv', index_col=False)"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"sku=pd.read_csv('Sku master test.csv', index_col=False)"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"t=pd.read_fwf('transfers test.txt')"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"