I'm writing a tiny Python library that fetches data from Horizons, JPL's solar system data and ephemeris computation service. An overview of their batch CGI is here. While the script is simple, I would like to make it as clear and standardized as possible. The idea is to initialize the HorizonsRe...

I'm taking my first programming course so please pardon if questions are too naive. I'm using Python Boto3 module and 'Click' library to build a Command Line Interface that manages EC2 instances. Code: @click.group() @cli.group('instances') def instances(): pass @instances.command('list') @cl...

This is basically based on the following question on stackoverflow which was based on a codewars assignment that can be found here Problem statement Complete the function scramble(str1, str2) that returns true if a portion of str1 characters can be rearranged to match str2, otherwise returns fal...

I'm just returning to Java after a multi-decade hiatus -- there are some nice new packages, such as java.nio. I need to convert an array of floats into bytes and vice versa. The floatToBytes() function feels okay, but I'm pretty certain that bytesToFloats() could be implemented better. Thoughts...

I need to get car info from a 3rd party web service and persist the data in my application DB. If my DB already has the car, I only update property values that may have changed. Otherwise, I create and save the car: @Transactional //Spring Transaction void saveCars() { //get CarInfo from a we...

Purpose of Code The purpose of the main function (get_player_penalties()) is to: Generate simple SQL statements from user input and a template Query a database using the generated SQL and return a summary table to the user Ultimately, I will reference this code to create similar functions (an...

I have a code return by my vendor which was slow. I need public comment on their code so that they can improve. . . .

I'm absolutely dumbfounded by this. I was trying to demonstrate to myself how much faster c++ is than even modern PHP. I ran a simple csv parsing program in both that have the same output. The csv file is 40,194,684 parsed down to 1,537,194 lines. PHP Code (runtime 42.750s): <?php $i_fp = fopen("...

Sorry for any mistake i am new and of 11 years. So first I found a simple series named Lebniez series for PI. I made a program and then realised that because It is an infinte series it will give approximation and the convergence rate is very slow. So here is the program I made after learning abo...

Looking for a most efficient way to replace some specific exception and to leave others exceptions treatment the same the same. try { // some business logic } catch(UniqueConstraintViolationException uex) when (!uex.IsFatal() && !ShouldRetry(descriptor, command, uex, ref retryResult)) { throw ...

I'm trying to write an extension (method chaining) for playing around a bit. What I made work is an extension to add an item to the list (what is pretty easy): IEnumerable<int> myList = originalList.Add(12); What I now want to do is: IEnumerable<int> myList = originalList.Add(12).If((list, @new) =>

Given the following generic memoize utility for pure functions with type hints: function memoize(callable $fn, callable $serialize = null): callable { $serialize = $serialize ? $serialize : 'serialize'; return function(...$args) use ($fn, $serialize) { static $cache = []; ...

I am trying to solve the warning, which avoids the call of a virtual method, I have seen different answers, but none of them seems to solve my doubt, I understand why this warning appears and is one of the ones you should not suppress. My code gets data from Matlab and uses a method to configure ...

I'm working on flattening a list of lists of arbitrary depth, and I have two solutions, but I'm wondering which is more Pythonic. # helper function def isList( x ): return isinstance( x, list ) def flatten3_h( *xs ): if ( len(xs) == 0 ): return [] # base case, empty list/tuple hd, tl = xs[ ...

I'm working with an HTML email template for a project. Everything works great on Gmail, Yahoo, and Outlook web email client, except for the Outlook desktop app v16.0, which I have a spacing rendering issue. I used mso conditional statement to target this specific version. But it doesn't seem to w...

This is an example of an actual project I am working on and I am wondering if this is the correct way to go continue going about it. Or if I should change it to use a different structure now it is still possible. The structure right now is the following: I have a main class that is main interface...

I started learning functional programming with JavaScript and I have the basic idea of Functors, container types and etc. I was trying to experiment with arrays but I don't know how to solve the problem of a function call that iterates over a array and returns returns another array. So the first ...

Goal: My goal is to filter datagrid by selected month from dropdown options. January, February, March etc... I'd like to know if there are easier methods to my current method.. Code: public Schedule() { InitializeComponent(); RefreshGrid(); Dictionary<string, string> allOptions = new...

I feel like there is a redundency between: def _determine_nodes_with_no_predecessors(nodes:List[Node])->List[str]: """ Given the list of nodes returns the identifiers of nodes that doesn't have any predecessor. """ nodes_ids_without_prdecessors = [] for node in nodes: ...

I'm trying to code some kind of EventManager to use events to change parameters into another script. The EventManager.cs, attached to an empty object "EventManager" in the scene is coded as follow: using System; using System.Collections.Generic; using UnityEngine; public class EventManager : Mo...

I am trying to solve the following problem: Input: Input is two arrays (Nx4, sorted in column-2) stored in datasets-1 and 2 in HDF5 file (input.h5). N is huge (originally belonging to 10 GB of file, hence stored in HDF5 file). Output: Subtracting each column-2 element of dataset-2 from dataset-1,...

Working on finding a way to reduce in-cell formula size and memory usage of my excel workbook, i came up with the idea to "load" (copi-paste) the reference sheet i was mentioning a lot with a workbook open. To make it more efficient i had a loop that verifies if the sheet has changed and only cop...

I have developed NoSQL database. At the moment it has no threads (async). When the database need to save data to disk, it blocks connections until it save. This method works OK, becauce save is fast - 3-4 sec, but I still can improve by background save. Here is the prototype of background save fa...

Im currently running an employee name substitution on card scan. Overall the code takes the entry trough the gun scan, "scan" trough the hidden reference sheet to find a match and then input the actual complete name. I had to implement that feature to my code so that names are always written the ...

Thanks in advance for your interest in my first PyPI project. While there happen to be a number of projects out there to help with creating & consuming Excel workbooks, I was unable to find one that made working with pywin32 any easier, so I built it myself. Using pywin32 for automating Excel wit...

Hello everyone so I have this bit of code here that works for copy and pasting an autofiltered range I just wanted to see if anyone knew a more efficient way to do so as it does take quite a while to complete it the way I have it now. I looked into trying to do so with a copying into an array but...