-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathrunDF.py
More file actions
35 lines (29 loc) · 1.05 KB
/
runDF.py
File metadata and controls
35 lines (29 loc) · 1.05 KB
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
from dfFunctions import df
class runDf(df):
a = df() # create an object
print(__name__)
frame = a.frame_from_csv()
a.convertToList(frame)
# print ( frame )
#
# a.printDfData(frame) # get general information about the dataframe
#
# a.print_loc(frame) # slice and prince data from the dataframe using loc (col and index names)
#
# a.print_iloc(frame) # slice and prince data from the dataframe using iloc (position)
#
# a.create_xlsx(frame) # write dataframe to excel
#
# frame = a.frame_from_xlsx()# read an excel file into a dataframe
#
# a.getstats(frame) # Sum, min, max, average and count
#
# a.groupby_sum(frame) # group records, eg records per city
#
# a.groupby_count(frame) # count how many rows are in a grouping
#
# a.query(frame) # filter records by value
#
# a.sort_frame(frame) # sort by column name or index
#
# a.unique(frame) # get unique records in a column