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 = ..
I want to randomly assign 1 value to the IsShade column (output) such that value 1 can be assigned only D times (see column Shading for ex 2 times or 5 times or 3 times) and have to iterate it for E times (Total column for ex 6 times or 8 times or 15 times) ..
I’m trying to get some information from a Json file that I got from a website and store it on a spreadsheet using requests and openpyxl, here’s the code: ObjectsToCheck = range(4284013, 4284025) for ID in ObjectsToCheck: Item = requests.get(Url + str(ID)) Json = Item.json() name = Json[‘name’] song = Json[‘customSong’] sheet["C4"] = name sheet["D4"] ..
I’m trying to add measured data to xlsx file and all I found is how to make new file and type to it… I have xlsx file which have sensors as names of collums and dates as names of rows: _______|sensor1|sensor2| 1.1.2020| 123 | 4598 | 2.2.2020| 789 | 8754 | and I want to ..
Write a program to calculate the orbit of a planet orbiting the Sun. Solve Newton’s equations of motion using Verlet’s algorithm. Perform the solution in reduced variables, ie the mass of the Sun and the planet, as well as Newton’s gravitational constant, consider equal to 1. Perform the calculation in case the planet is initially ..
I want to randomly assign 1 value to IsShade column (output) such that value 1 can be assigned only D times (see column Shading for ex 2 times or 5 times or 3 times) and have to iterate it for E times (Total column for ex 6 times or 8 times or 5 times) There ..
Basically I have a .csv file with similar data structure to the following: Name | Department | Committees | Years Jack | Finance | Party | 7.0 Jen | Marketing | Risk | 15.0 I would like to be able to create individual markdown files based on the Name column in the .csv and then ..
#Import the xlrd module import xlrd #set the location of the file you want to analyze: loc = ("pivot.xlsx") #identify it was as an Excel workbook wb = xlrd.open_workbook(loc) #select the sheet you want to review sheet = wb.sheet_by_index(0) #we can read a particular cell’s value: sheet.cell_value(0,0) #Count the total number of rows: r1 = ..
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 = ..
Hello I have an ETL process and updating SQL with cleaned data and after I need to refresh all my reports in company server around 40 50 report instead of going and click refresh Im looking a way to mak e it automated, here is my code which is running in C and D. import ..