Python json.loads returning JSONDecodeError Expecting ',' delimiter Problem Description: I am trying to parse a JSON raw string using json.loads but its throwing following error JSONDecodeError at /octopus/entries/53/test_sample_job/ Expecting ‘,’ delimiter: line 3 column 27 (char 48) My json string data is as follows and I am getting error when i did json.loads(data) data = … Read more
Python nested loops inside dict Problem Description: I have a dict exchange rates. It has 3 levels: rates, date and currency. "rates": { "2022-11-30": { "AED": 0.06019, "AFN": 1.442036, "ALL": 1.836137, "AMD": 6.464451, "ANG": 0.029525, "AOA": 8.304432, "ARS": 2.741601, ……………. etc. I want to write a loop that first will capture the date in a … Read more
Shadow name error and Local variable not used Problem Description: self teaching myself how to code and starting with this book and a Udemy course. have been working on this practice project for 2 days now and I keep running into "Local variable ‘streaks’ not used when I have the streak counter placed inside the … Read more
Appending at new line in Python using csv library Problem Description: I am unable to handle case where user forgot to put newline. I am trying to append new line to a csv file in python using below code – with open(local_file_location, ‘a’) as file: writer = csv.writer(file) writer.writerow(row) But in case if file do … Read more
Create 2D numpy array from buffer Problem Description: Consider a system with n_channels transmitting n_samples at a given sampling rate. The 1D buffer containing the timestamps and the 2D buffer containing (n_channels, n_samples) is: from ctypes import c_double, c_float # Assume a 2-second window, 3 channels, sampled at 1024 Hz # data: (n_channels, n_samples) = … Read more
AttributeError: type object 'AdminSignUpForm' has no attribute 'as_view' why is this not working? Problem Description: Creating a simple multiple users app. The as_view method is working with all the other views but not on this particular one. I have no clue why. Here are my models class User(AbstractUser): is_student = models.BooleanField(default=False) is_teacher = models.BooleanField(default=False) is_admin … Read more
How to read a file in append mode in python? Problem Description: I have just recently started learning about File Handling in python. But I got stuck into a problem. As mentioned in my textbook In append mode, both reading and writing operations can take place. But when I tried this code: with open(‘first.txt’,’a+’) as … Read more
How can we call dataframe functions like (mean, median, mode, min …) dynamically Problem Description: fields = {‘rule1′:’min’,’rule2′:’max’} For example: for key, value in fields.items(): Dataframe.{value}() Solution – 1 You can try getattr as below fields = { ‘mean’: df.mean, ‘median’: df.median, ‘mode’: df.mode, ‘min’: df.min, ‘max’: df.max } for key, value in fields.items(): # … Read more
How can we call dataframe functions like (mean, median, mode, min …) dynamically Problem Description: fields = {‘rule1′:’min’,’rule2′:’max’} For example: for key, value in fields.items(): Dataframe.{value}() Solution – 1 You can try getattr as below fields = { ‘mean’: df.mean, ‘median’: df.median, ‘mode’: df.mode, ‘min’: df.min, ‘max’: df.max } for key, value in fields.items(): # … Read more
Calculate time between time in python and time in mysql database Problem Description: ` import datetime now = datetime.datetime.now () tgl = now.strftime("%Y-%m-%d") y = now.strftime (‘%H:%M:%S’) print(y) >>> 20:01:10 crsr.execute("SELECT * FROM tblsolar WHERE tanggal LIKE ‘%s’ AND id LIKE ‘1001’ ;" % (tgl)) res = crsr.fetchall() for i in res: z = i[9] … Read more