-
Notifications
You must be signed in to change notification settings - Fork 2
/
parse_csv.py
59 lines (47 loc) · 1.74 KB
/
parse_csv.py
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
import os
import csv
import pandas as pd
def findFile(folderName, path_list):
# os.chdir(folderName)
item_list = os.listdir(folderName)
print(item_list)
# num_folder = 0
# for file in item_list:
# if (os.path.isdir(file)):
# num_folder += 1
# print(num_folder)
for i, item in enumerate(item_list):
if os.path.isdir(item):
print("folder = ", item)
full = os.path.join(folderName, item)
print(full)
findFile(full, path_list)
else:
file_ext = item.split(".")
file_ext = file_ext[-1] if len(file_ext) > 1 else ""
if(item.find("extracted_") != -1 and file_ext == "csv"):
path_list.append(os.path.join(folderName, item))
# path_list[i] = os.path.join(folderName, item)
print(path_list)
return path_list
def main():
dir_path = os.path.dirname(os.path.realpath(__file__))
path_list = []
for path, subdirs, files in os.walk(dir_path):
for name in files:
file_ext = name.split(".")
file_ext = file_ext[-1] if len(file_ext) > 1 else ""
if(name.find("extracted_") != -1 and file_ext == "csv"):
path_list.append(os.path.join(path, name))
parent_df = pd.DataFrame()
for path in path_list:
child_df = pd.read_csv(path, encoding='utf-8')
parent_df = pd.concat([parent_df, child_df])
# print (os.path.join(path, name))
# empty_list = []
# path_list = findFile(dir_path, empty_list)
# parent_df = pd.DataFrame()
# for path in path_list:
parent_df.to_csv('recap.csv', index=False, encoding="utf-8")
if __name__ == "__main__":
main()