I want to replace some acquaintance values by keywords to specific value, converting both "google" and "searching google" to "seo" I tried replace but you should specify all the values to replace with and that's not possible. if there is…
I have JSON data string from which I try to extract the highest value of "id" without iterating. This is the JSON data string: "ball_coordinates": [ { "id": 3938706, "fixture_id": 18795544, "period_id": 4644037, "timer": "17:20", "x": "106", "y": "57" },…
Hello I am new to coding and I am trying to open an excel file. I've install the module for openpyxl and I know have at least somewhere because every time I type in command prompt pip install openpyxl it…
I am new here , need some help with writing to json file: I have a dataframe with below values, which is created by reading a excel file need to write this to json file with object as column dtls…
Thank you for taking the time to read this. I am trying to use the LIKE operator to open workbooks. Previously I went with this code which works really well Report_Name = "XYZ.xls" Workbooks.open Filename:= ThisWorkbook.Path & Report_Name My main…
Here is my dataframe: df year 2022 2021 0 return on equity (roe) 160.90% 144.10% 1 average equity 62027.9677 65704.372 2 net profit margin 0.2531 0.2588 3 turnover 1.1179 1.0422 4 leverage 5.687 5.3421 I want to write it into…
I have a problem in which I cannot trace the error/problem when trying to export and download my Users table in excel using Maatwebsite I've followed step by step with this reference here link but it didn't export the data…
I have an issue joining two datasets with companies that have inconsistent names. In the first dataset, I have event data which consist of Company Name, Company ID, etc. In the second dataset, I have all the information about the…
I've written a piece of code for converting a DataTable object(which is created from an uploaded excel) to a list of custom object(ExcelTemplateRow in my case). While this method works fine when the values are supplied as expected(in terms of…
I have had a problem for days and am now reporting here. I want to export several JSON files to an Excel spreadsheet. The JSON keys should form the headers and the values should be listed under the headers. Unfortunately,…