-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathPandamonium.py
53 lines (49 loc) · 1.57 KB
/
Pandamonium.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
"""
Pandamonium
------------
Serialize + compress Pandas DataFrames.
"""
import pandas
def compress(dataframe, file_):
csv = dataframe.to_csv()
csv = csv.replace(",1", chr(11))
csv = csv.replace(",2", "º")
csv = csv.replace(",3", chr(127))
csv = csv.replace(",4", "¦")
csv = csv.replace(",5", chr(15))
csv = csv.replace(",6", chr(26))
csv = csv.replace(",8", chr(18))
csv = csv.replace(",9", chr(19))
csv = csv.replace(",-", chr(24))
csv = csv.replace(",7", chr(17)).encode(encoding="UTF-8")
file = open(file_, "wb") # Fix this part
file.write(csv)
file.close()
return "Success!"
def decompress(file):
a = open(file, "rb")
a = a.read().decode(encoding="UTF-8")
a = a.replace(chr(26), ",6")
a = a.replace("¦", ",4")
a = a.replace(chr(11), ",1")
a = a.replace("º", ",2")
a = a.replace(chr(127), ",3")[1:]
a = a.replace(chr(15), ",5")
a = a.replace(chr(17), ",7")
a = a.replace(chr(18), ",8")
a = a.replace(chr(19), ",9")
a = a.replace(chr(24), ",-")
b = open(file, "w")
b.write(a)
b.close()
df = pandas.read_csv(file)
return df
if __name__ == "__main__":
import time
import getpass
a = pandas.DataFrame({"Test 1-3": [12, 23, 34], "Test 4-6": [48, 65, 53], "Test 7-9": [93, 88, 70]})
print(compress(dataframe=a, file_=f"C:/Users/{getpass.getuser()}/Desktop/testing.pdc"))
time.sleep(15)
print("Waiting...")
print(decompress(f"C:/Users/{getpass.getuser()}/Desktop/testing.pdc"))
""