Need EqualIgnoreCase when getting index
Converting to upper and lower case in Java
Alice has a secp256k1 key pair that she used some time ago when she communicated with Bob. Bob can no longer user secp256k1 but he only uses ed25519 instead.  Is there a secure algorithm that Bob can use to derive an ed25519 pubkey from original Alice's secp256k1 pub key and also Alice can derive the matching ed25519 private key from her original secp256k1 private key such that they can communicate securely via ed25519 encrypted messages?  Thanks! Adding the PHP json extension Implementing a PIVOT query How can I pivot the following SELECT statement:           SELECT sc.CID,                 sc.CodeName     as OverviewText,                 scRAG.CodeName  as RAGStatusText             FROM StatusCode      sc LEFT OUTER JOIN ProjectOverview po               ON sc.CID          = po.ProjectOverviewCID              AND po.ProjectId    = 180 LEFT OUTER JOIN StatusCode      scRAG               ON po.RAGStatusCID = scRAG.CID           WHERE sc.SCID         = 18   Such statement yields the result set that follows:  CID OverviewText    RAGStatusText --- ------------    ------------- 153 Cost            Green 154 Requirements    Yellow 155 Schedule        NULL 156 Technical       NULL 157 Testing         NULL   But, I want it to return one single row with 10 values, as shown bellow:   ----------------------------------------------------------------------------------------------  | Cost | Green | Requirements | Yellow | Schedule | NULL | Technical | NULL | Testing | NULL |  ----------------------------------------------------------------------------------------------   Can I pivot on CID? Is it ok to use an alternate account while my main user is restricted? I'm new to Stack Exchange, and my main user only has 16+ rep. And it's been blocked in Code Review. I need to use Code Review today. Should I use an alternate account? Every natural number can be written as the sum of distinct Fibonacci numbers? What's in a name: hyperparameters So in a normal distribution, we have two parameters: mean $\mu$ and variance $\sigma^2$. In the book Pattern Recognition and Machine Learning, there suddenly appears a hyperparameter $\lambda$ in the  regularization terms of the error function.  What are hyperparameters? Why are they named as such? And how are they intuitively different from parameters in general? How do I display 2 sections side-by-side? I understand that information cannot be transmitted at a velocity greater than speed of light. I think of this in terms of the radio broadcast: the station sends out carrier frequencies $\omega_c$ but the actual content is carried in the modulated wave, the sidebands $\omega_c\pm\omega_m$. The modulation envelop has its group velocity and this is the speed at which information is being transmitted. We also know, for example, that x-rays in glass have a phase velocity which is greater than the speed of light in vacuum.   My question is, what exactly is it that is travelling faster than the speed of light?    EDIT: I know it couldn't be anything physical as its superluminal. My problem is, what is it that has absolutely no information content yet we associate a velocity with it. If Eren Jaeger dies without transfering his titan powers, will both powers transfer to the same child? It's told in the story that if a titan shifter dies without transferring his power, this power will go to an eldian person who just was born. If Eren Jaeger dies without transferring his titan powers, will the attack titan and the founding titan go to different persons?  Note that his is not a duplicate of  as this is not about what happens when a titan shifter dies. But what happens if a titan shifter with 2 powers dies, which is not answered in the answer. In Python, what's the difference between 'except Exception as e' and 'except Exception, e' This is a follow up from this .  I'm using this slightly modified script to enumerate all installed MSI packages:  strComputer = "."  Set objWMIService = GetObject("winmgmts:" &amp; _     "{impersonationLevel=impersonate}!\\" &amp; _     strComputer &amp; _     "\root\cimv2")  Set colSoftware = objWMIService.ExecQuery _     ("SELECT * FROM Win32_Product")     If colSoftware.Count &gt; 0 Then     For Each objSoftware in colSoftware         WScript.Echo objSoftware.Caption &amp; vbtab &amp; _         objSoftware.Version     Next Else     WScript.Echo "Cannot retrieve software from this computer." End If   What is surprising however, is its abysmal performance. Enumerating the 34 installed MSI packages on my XP box takes between 3 and 5 minutes !  By comparison, the Linux box that sits besides is taking 7s to enumerate 1400+ RPMs... sigh  Any clues on this ? Why time is considered a dimension? Limits involving factorials $\lim_{N\to\infty} \frac{N!}{(N-k)!N^{k}}$ I am trying to calculate the following limit  $$\lim_{N\to\infty} \frac{N!}{(N-k)!N^{k}}$$ where $k$ can be any number between $0$ and $N$.  I thought of the following:  If I take the logarithm of the expression then I get:  $$\lim_{N\to\infty} \left(\log(N!)-\log((N-k)!)-k\log N\right)$$    Using the Stirling formula this can be approximated as:  $$\lim_{N\to\infty} \left(N\log(N)-(N-k)\log(N-k)-k\log N\right)$$  Now there are two cases: If $k$ is $N$, then the second term vanishes and the remaining terms cancel. If $k$ is smaller than $N$, then I can drop the $k$ inside the second logarithm and all the terms cancel. So the limit $$\lim_{N\to\infty} \log\left(\frac{N!}{(N-k)!N^{k}}\right)=0$$ Which means that: $$\lim_{N\to\infty} \frac{N!}{(N-k)!N^{k}}=1$$ I don't know if this is mathematically rigorous. Would like some help. Thanks Time complexity of nested for-loop Where can I ask a question about finding general software that meets certain requirements? Limit- almost finished, however hint needed. Random forest regression not predicting higher than training data I've noticed that when building random forest regression models, at least in R, the predicted value never exceeds the maximum value of the target variable seen in the training data. As an example, see the code below. I'm building a regression model to predict mpg based on the mtcars data. I build OLS and random forest models, and use them to predict mpg for a hypothetical car that should have very good fuel economy. The OLS predicts a high mpg, as expected, but random forest does not. I've noticed this in more complex models too. Why is this?   &gt; library(datasets) &gt; library(randomForest) &gt;  &gt; data(mtcars) &gt; max(mtcars$mpg) [1] 33.9 &gt;  &gt; set.seed(2) &gt; fit1 &lt;- lm(mpg~., data=mtcars) #OLS fit &gt; fit2 &lt;- randomForest(mpg~., data=mtcars) #random forest fit &gt;  &gt; #Hypothetical car that should have very high mpg &gt; hypCar &lt;- data.frame(cyl=4, disp=50, hp=40, drat=5.5, wt=1, qsec=24, vs=1, am=1, gear=4, carb=1) &gt;  &gt; predict(fit1, hypCar) #OLS predicts higher mpg than max(mtcars$mpg)       1  37.2441  &gt; predict(fit2, hypCar) #RF does not predict higher mpg than max(mtcars$mpg)        1  30.78899 Windows 7 shows red "X" on network icon, but I'm connected Confusion between register size, address size, data size I started learning about pointers in C++ and I figured I should educate myself a bit on how memory works and is accessed. I read that when we say a processor is 64-bit, it has a 64-bit register and can access 2^64 address locations. I also read that it can fetch 64/8, so 8 bytes of data at a time, but the data bus is not the same thing as the register right? Do they need to be the same size or does that just happen to be the case usually? And is it the size of the register or the data bus size that determines what we refer to it as, such as 32/64-bit? Also is there a difference between register size and address size? Unexpected Results From Clicking The Unanswered Button