Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
from abc import abstractmethod, ABC
import pandas as pd
class Adapter(ABC):
@abstractmethod
def read_csv(self): pass
@abstractmethod
def sort(self, *args, **kwargs): pass
@abstractmethod
def set_column_value(self, *args, **kwargs): pass
@abstractmethod
def set_column_values(self, *args, **kwargs): pass
@abstractmethod
def get_column_name_by_index(self, *args, **kwargs): pass
@abstractmethod
def get_column_index_by_index(self, *args, **kwargs): pass
@abstractmethod
def get_columns(self, *args, **kwargs): pass
@abstractmethod
def drop_colunn_by_name(self, *args, **kwargs): pass
@abstractmethod
def get_column_values_as_list(self, *args, **kwargs): pass
class PandasAdapter:
def __init__(self, data_frame):
self.__data_frame = data_frame
@classmethod
def read_csv_data(cls, path):
data_frame = pd.read_csv(path)
return PandasAdapter(data_frame)
def get_column_values(self, column_name):
return self.__data_frame[column_name]
def get_column_values_as_list(self, column_name):
return self.__data_frame[column_name].tolist()
def get_columns(self):
return self.__data_frame.columns
def drop_column_by_index(self, index):
column = self.get_column_name_by_index(index)
self.__data_frame.drop(columns=[column], inplace=True)
def drop_column_by_name(self, name):
self.__data_frame.drop(columns=[name], inplace=True)
def get_column_index_by_name(self, name):
return self.__data_frame.get_loc(name)
def get_column_name_by_index(self, index):
column_names = self.__data_frame.columns
return column_names[index]
def set_column_value(self, column_name, value):
self.__data_frame[column_name] = value
def sort(self, column_name, ascending=True):
self.__data_frame.sort_values(by=[column_name],
ascending=ascending,
inplace=True)
def set_column_values(self, column, values):
self.__data_frame[column] = values