Category : excel

Hello, I rowt this code to extract data from an SQLite database and make a data frame with pandas. import pandas as pd import sqlite3 import os search_path = "C:UsersliranOneDriveDesktopprojectsraw_dataNEMESIS" def find_sqlite_files_box(search_path_os): file_roots = [] for root, dir, file in os.walk(search_path_os, topdown=True): for name in file: file_roots.append(os.path.join(root, name)) return file_roots list_of_roots = find_sqlite_files_box(search_path) s3db_file_list = ..

Read more

I have data in an excel file and I need a way to identify if there are some rows that are identicals. My data are more than 1000 rows and I want to highlight the double rows in the excel document. This is the code that I use to identify the double lines: file = ..

Read more