#import Module, connect to google drive
import os
import pandas as pd
import re
import json
from google.colab import drive
from functools import reduce
drive.mount('/content/drive', force_remount=False)
path = "/content/drive/MyDrive/Colab_Notebooks/data_base/MySQL/"
#Panda read excel to dataFrame
df = pd.read_excel(f"{path}Mp3_DataBase.xlsx", dtype=str)
df.fillna("None", inplace=True)
allData = df.values.tolist()
print(allData)
column_name = df.columns.tolist()
print(column_name)
#2-Dimensional Array to dataFrame
df = pd.DataFrame(allData, columns=column_name)
df
#2-Dimensional Array to Json (Array-Object) Fromat
json_data = list(map(lambda arr: dict(zip(column_name, arr)), allData))
print(json_data)
json_data2 = df.to_json(orient='records')
print(json_data2)
#Json (Array-Object) Fromat to 2-Dimensional Array
df_table = pd.DataFrame(json_data)
allData = df_table.values.tolist()
print(allData)
column_name = df_table.columns.tolist()
print(column_name)
#Data Frame to Object-Array
obj = {}
for i, column in enumerate(column_name):
obj[column] = list(map(lambda x: x[i], allData));
print(obj)
#Data Frame to dobule Dict
print(df.to_dict())
#Array indexOf() and lastIndexOf()
def lastIndexOf(alist, value):
return len(alist) - alist[-1::-1].index(value) -1
def indexOf(alist, value):
try:
return alist.index(value)
except:
return -1