If you have working code that you're looking to have peer-reviewed for improvement, your post belongs on Code Review, which was established just for that purpose. If that's not what you're asking, then please edit your post to clearly explain the problem you're having with the code you've posted and ask a specific question related to that code. — Ken White 49 secs ago
For a homework assignment, we were tasked to create a basic calculator in MySQL and store it in a procedure. I believe I did a solid job but am looking to see where I can improve.
DELIMITER $$
CREATE PROCEDURE Calculate(IN Num1 INT, IN Num2 INT, IN operation VARCHAR(100))
BEGIN
IF operation = "...
My first post at code review, hope this goes well. I am reading an Excel file using Pandas and I feel like there has to be a better way to handle the way I create column names. This is something like the excel file I'm reading:
1 2 # '1' is merged in the two cells ab...1
0
I got a bit of a strange JS issue that I could use help on if anyone has time…
Basically if you flick the slider just the wrong way then it'll spin infinitely rather than just settle on a slide and stop. It's a bit hard to get it to do that. I think it has something to do with spinning past the ...
0
I wrote this for a class project, the backend for this dog voting website. I noticed duplicate code among multiple functions I was writing to be deployed as a cloud function: they all were wrapped in try/except blocks that returned either 200 and JSON or 500 and a traceback. (I understand that it...
This is the new code, I am unsure if I made the suggestions the the suggestion intended on my previous post First Python program: Tic-Tac-Toe.
I have only been working on programming for about 3 weeks so anymore suggestions or insight on the original post of the suggestions would be more than w...
I have a method that creates a database record...
the data to be added is in the constructor.
DataBaseRecordCreator DataBaseRecordCreator = new DataBaseRecordCreator("Bob", 35);
there is only one method currently called with to following code...
if(CreateDatabaseRecord() == "sucess")
{
Cons...0
0
Q: Unable to receive SOAP POST request at client side. Getting error Request method 'GET' not supported
I am creating a Client to consume the SOAP request. The Client is sending request using HTTP POST. Below are two requests that I need to consume:
Request 1:
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:abc="http://pay_t...
Best way to loop through cells :
for or for each cls in rng ?
Sub for()
For i = a To b
For j = c To d
'things to cells(i,j)
Next j
Next i
End Sub
or
sub ForEach()
dim cls as variant
dim rng as range
set rng = myrange
for each cls in rng
'Things to cls
next cls
e...
-1
0
0
So I have been practicing competitive coding for a while now and am using codeforces.com for the same. I recently encountered a problem called "One Dimensional Japanese Crossward" on that site ( https://codeforces.com/problemset/problem/721/A ). After lots of tries and lots of fails, I was fin...
I am working on Valid Perfect Square - LeetCode
and wrote a standard leftmost bisect search to solve the problem
class Solution:
def isPerfectSquare(self, num: int) -> bool:
#base case 1
if num == 1: return True
lo = 1
hi = num
#recur case
w...
I have the following working code, but it is too slow because I have to run the same code for several files inside a folder. Please help me avoid the nested for loop or make it more efficient.
def create_nodes(self):
for child in self.tree.getroot():
columnNames = child.attrib
...
How can i make this function faster? I am calculating parameters for timeseries & the data size is very big
def param(data_param):
w = []
x = []
y = []
z = []
p = d = q = range(0, 2) # Define the p, d and q parameters to take any value between 0 and 2
pdq = list(itertools...0
0
I'm trying to extract the key value in C from a string in a config file which may have arbitrary whitespace leading and trailing the string. This is what I've come up with so far. It's not quite right yet. It's been quite some time since I've picked up C and have been spoiled by baked-in string ...
2
0
-1
0
0
I have a list of orders and for some order fields I need get the data that is common among the orders. If the data is not in common, I should indicate null. I collect the common data in a CommonData object. In addition, I also store the order codes and order ids associated with the CommonData.
...0
The task:
Implement integer exponentiation. That is, implement the pow(x, y)
function, where x and y are integers and returns x^y.
Do this faster than the naive method of repeated multiplication.
For example, pow(2, 10) should return 1024.
Solution 1
function pow(x, y) {
if (...1
0
0
0
In a bucket, there are total 100 balls, in which 10 are red, 40 are green and remaining 50 are black. Every ball has a numeric unique tag starting from 1 to 100, like red balls have tag 1 to 10 than green balls have their tags from 11 to 50 and rest black tags are from 51 to 100.
Now If I take a...
-2
0
0
Ive got some code which converts data from hours to days. I am wondering if there are any improvements which could be made to make it more efficient or any other improvements in general that could be made? other information:for t = Int((n - 1) / 24) + 1, the n is the amount of rows of data. u is ...
0
I'm new to Python, for a school project I created a "fishing simulator". Basically, use of random. I know that my code is repetitive towards the end but I don't know how to simplify it.
import time
import random
fishing = True
a = b = c = d = e = 0 #define multiple variables as same thing
print ...
