Questions

Read XML file into XmlDocument

I am very new to C#. I have XML file (text.xml). I want to read that in `XmlDocument` and store the stream in string variable.

16 Nov at 13:5

pandas GroupBy columns with NaN (missing) values

I have a DataFrame with many missing values in columns which I wish to groupby: ``` import pandas as pd import numpy as np df = pd.DataFrame({'a': ['1', '2', '3'], 'b': ['4', np.NaN, '6']}) In [4]: ...

Pandas split DataFrame by column value

I have `DataFrame` with column `Sales`. How can I split it into 2 based on `Sales` value? First `DataFrame` will have data with `'Sales' < s` and second with `'Sales' >= s`

15 Apr at 13:15

Mutex example / tutorial?

I was trying to understand how mutexes work. Did a lot of Googling but it still left some doubts of how it works because I created my own program in which locking didn't work. One absolutely non-intui...

Extract only right most n letters from a string

How can I extract a `substring` which is composed of the rightmost six letters from another `string`? Ex: my string is `"PER 343573"`. Now I want to extract only `"343573"`. How can I do this?

21 Sep at 09:29

UILabel text margin

I'm looking to set the left inset/margin of a `UILabel` and can't find a method to do so. The label has a background set so just changing its origin won't do the trick. It would be ideal to inset the ...

22 Dec at 11:54

Regex to match string containing two names in any order

I need logical AND in regex. something like jack AND james agree with following strings - 'hi here is '- 'hi here is '

9 Dec at 02:48

Converting string to title case

I have a string which contains words in a mixture of upper and lower case characters. For example: `string myData = "a Simple string";` I need to convert the first character of each word (separated...

25 Apr at 09:52

A SQL Query to select a string between two known strings

I need a SQL query to get the value between two known strings (the returned value should start and end with these two strings). An example. "All I knew was that the dog had been very bad and require...

21 Aug at 16:18

SQL count rows in a table

I need to send a SQL query to a database that tells me how many rows there are in a table. I could get all the rows in the table with a SELECT and then count them, but I don't like to do it this way. ...

7 Mar at 16:17

How to compare DateTime in C#?

I don't want user to give the back date or time. How can I compare if the entered date and time is LESS then the current time? If the current date and Time is 17-Jun-2010 , 12:25 PM , I want user c...

9 Sep at 07:1

Difference between Subquery and Correlated Subquery

Is the following piece of SQL Query a normal query or a Correlated Subquery ?? ``` SELECT UserID, FirstName, LastName, DOB, GFName, GLName, LoginName, ...

Update query PHP MySQL

Can anybody help me understand why this update query isn't updating the fields in my database? I have this in my php page to retrieve the current values from the database: ``` <?php $query = mysql...

3 Apr at 13:10

Left Join without duplicate rows from left table

Please look at the following query: ``` Content_Id Content_Title Content_Text 10002 New case Study New case Study 10003 New case Study New case Study 10004 New case Study New case S...

31 Mar at 18:58

How to make a simple popup box in Visual C#?

When I click a button, I want a box to popup on the screen and display a simple message. Nothing fancy really. How would I do that?

27 Nov at 00:19

Cross origin requests are only supported for HTTP but it's not cross-domain

I'm using this code to make an AJAX request: ``` $("#userBarSignup").click(function(){ $.get("C:/xampp/htdocs/webname/resources/templates/signup.php", {/*params*/}, function(respo...

31 Mar at 21:46

Get week number (in the year) from a date PHP

I want to take a date and work out its week number. So far, I have the following. It is returning 24 when it should be 42. ``` <?php $ddate = "2012-10-18"; $duedt = explode("-",$ddate); $date = mkti...

16 Apr at 05:56

What does ${} (dollar sign and curly braces) mean in a string in JavaScript?

I haven't seen anything here or on MDN. I'm sure I'm just missing something. There's got to be some documentation on this somewhere. Functionally, it looks like it allows you to nest a variable inside...

ReactJS: Warning: setState(...): Cannot update during an existing state transition

I am trying to refactor the following code from my render view: ``` <Button href="#" active={!this.state.singleJourney} onClick={this.handleButtonChange.bind(this,false)} >Retour</Button> ``` to a ...

23 May at 09:29

Invoke(Delegate)

Can anybody please explain this statement written on this [link](http://msdn.microsoft.com/en-us/library/system.windows.forms.control.invoke.aspx) ``` Invoke(Delegate): ``` Executes the specified d...

23 Dec at 03:49

TypeError: only length-1 arrays can be converted to Python scalars while trying to exponentially fit data

``` f=np.loadtxt('Single Small Angle 1.txt',unpack=True,skiprows=2) g=np.loadtxt('Single Small Angle 5.txt',unpack=True,skiprows=2) x = f-g[:,:11944] t=range(len(x)) m=math.log10(abs(x)) np.polyfit(...

10 Feb at 20:48

No space left on device

I am getting the error "No space left on device" when i tried to scp some files to a centos machine, tried to check: ``` [root@...]# df -h Filesystem Size Used Avail Use% Mounted on /dev/m...

23 Dec at 11:23

npm install error - unable to get local issuer certificate

I am getting an `unable to get local issuer certificate` error when performing an npm install: ``` typings ERR! message Unable to read typings for "es6-shim". You should check the entry paths in "es...

8 Apr at 07:52

Moment js get first and last day of current month

How do I get the first and last day and time of the current month in the following format in moment.js: > 2016-09-01 00:00 I can get the current date and time like this: `moment().format('YYYY-MM-DD...

23 May at 12:3

SQL sum with condition

I currently have a large SQL statement which i add the following line to in order to get the total cash for each transaction ID (which are unique): ``` select sum(cash) from Table a where a.branch = ...

23 Dec at 10:6