mirror of
https://github.com/fenago/data-science.git
synced 2026-05-04 08:31:59 +00:00
fenago
37 lines
1.2 KiB
Python
37 lines
1.2 KiB
Python
import unittest
|
|
import import_ipynb
|
|
import pandas as pd
|
|
import pandas.testing as pd_testing
|
|
from sklearn.cluster import KMeans
|
|
|
|
class Test(unittest.TestCase):
|
|
def setUp(self):
|
|
import Exercise12_01
|
|
self.exercises = Exercise12_01
|
|
|
|
self.file_url = '../Dataset/taxstats2015.csv'
|
|
self.df = pd.read_csv(self.file_url)
|
|
self.postcode_url = '../Dataset/taxstats2016individual06taxablestatusstateterritorypostcodetaxableincome%20(2).xlsx'
|
|
self.postcode_df = pd.read_excel(self.postcode_url, sheet_name='Individuals Table 6B', header=2)
|
|
self.merged_df = pd.merge(self.df, self.postcode_df, how='left', on='Postcode')
|
|
|
|
|
|
|
|
def test_file_url(self):
|
|
self.assertEqual(self.exercises.file_url, self.file_url)
|
|
|
|
def test_postcode_url(self):
|
|
self.assertEqual(self.exercises.postcode_url, self.postcode_url)
|
|
|
|
def test_df(self):
|
|
pd_testing.assert_frame_equal(self.exercises.df, self.df)
|
|
|
|
def test_postcode_df(self):
|
|
pd_testing.assert_frame_equal(self.exercises.postcode_df, self.postcode_df)
|
|
|
|
def test_merged_df(self):
|
|
pd_testing.assert_frame_equal(self.exercises.merged_df, self.merged_df)
|
|
|
|
if __name__ == '__main__':
|
|
unittest.main()
|