-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathPatterns.txt
More file actions
148 lines (122 loc) · 2.86 KB
/
Copy pathPatterns.txt
File metadata and controls
148 lines (122 loc) · 2.86 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
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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
#Square triangle
'''n=int(input())
for i in range(n):
for j in range(n):
print('*',end=' ')
print()'''
#increase trainagle
'''n=int(input())
for i in range(n):
for j in range(i+1):
print('*',end=' ')
print()'''
#decrease trianing
'''n=int(input())
for i in range(n):
for j in range(i,n):
print('*',end=' ')
print()'''
#right side traingle
'''n=int(input())
for i in range(n):
for j in range(i,n):
print(' ',end='')
for j in range(i+1):
print('*',end='')
print()'''
'''n=int(input())
for i in range(n):
for j in range(i+1):
print(' ',end=' ')
for j in range(i,n):
print('*',end=' ')
print()'''
#hill triangle
'''n=int(input())
for i in range(n):
for j in range(i,n):
print(' ',end='')
for j in range(i):
print('*',end='')
for j in range(i+1):
print('*',end='')
print()'''
#reverse a triangle
'''n=int(input())
for i in range(n):
for j in range(i+1):
print(' ',end='')
for j in range(i,n-1):
print('*',end='')
for j in range(i,n):
print('*',end='')
print()'''
'''n=int(input())
for i in range(n-1):
for j in range(i,n):
print(' ',end='')
for j in range(i):
print('*',end='')
for j in range(i+1):
print('*',end='')
print()
for i in range(n):
for j in range(i+1):
print(' ',end='')
for j in range(i,n-1):
print('*',end='')
for j in range(i,n):
print('*',end='')
print()'''
'''n=int(input())
for i in range(1,n+1):
for j in range(1,n+1):
print(i,end=' ')
print()'''
'''n=int(input())
for i in range(1,n+1):
for j in range(1,n+1):
print(j,end=' ')
print()'''
'''n=int(input())
c=1
for i in range(1,n+1):
for j in range(1,n+1):
print(c,end=' ')
c+=1
print()'''
'''n=int(input())
c=65
for i in range(1,n+1):
for j in range(1,n+1):
print(chr(c),end=' ')
c+=1
print()'''
'''print(ord('a'))
print(chr(65))'''
'''n=int(input())
for i in range(n):
for j in range(i + 1):
print(' ', end=' ')
for j in range(i, n - 1):
print('*', end=' ')
for j in range(i,n):
print("*", end=' ')
print()'''
import pandas as pd
def process_dataframe(file_path: str, header_row: int = 7) -> pd.DataFrame:
"""
Dynamically processes an Excel file by:
- Reading from a specific header row
- Assigning headers
- Cleaning unnecessary rows/columns
- Returning a clean DataFrame
"""
# Step 1: Read Excel file using pandas
df = pd.read_excel(file_path, header=header_row)
# Step 2: Drop columns that are completely empty
df.dropna(axis=1, how='all', inplace=True)
# Step 3: Drop rows that are completely empty
df.dropna(axis=0, how='all', inplace=True)
# Step 4: Return the clean DataFrame
return df