See what the Stackoverflow community is most excited about today.
Date: 2017-10-24
-
pandas iloc vs ix vs loc explanation?
tags: python, pandas, indexing, dataframe
237 votes, 3 answers and 140573 views
\r\n Can someone explain how these three methods of slicing are different?\nI've seen the docs, \nand I've seen these answers, but I still find myself unable to explain how the three are different. To me, ...\r\n
-
What is the meaning of the prefix N in T-SQL statements?
tags: sql, sql-server, tsql
223 votes, 3 answers and 154889 views
\r\n I have seen prefix N in some insert T-SQL queries. Many people have used N before inserting the value in a table.\n\nI searched, but I was not able to understand what is the purpose of including the N ...\r\n
-
MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
tags: sql, mysql, performance
186 votes, 3 answers and 287644 views
\r\n What is main difference between INSERT INTO table VALUES .. and INSERT INTO table SET?\n\nExample:\n\nINSERT INTO table (a, b, c) VALUES (1,2,3)\n\nINSERT INTO table SET a=1, b=2, c=3\r\nAnd what about ...\r\n
-
How to split a large text file into smaller files with equal number of lines?
tags: bash, file, unix
277 votes, 7 answers and 263721 views
\r\n I've got a large (by number of lines) plain text file that I'd like to split into smaller files, also by number of lines. So if my file has around 2M lines, I'd like to split it up into 10 files that ...\r\n
-
tags: c#, html, html-agility-pack
560 votes, 6 answers and 302568 views
\r\n How do I use the HTML Agility Pack?\n\nMy XHTML document is not completely valid. That's why I wanted to use it. How do I use it in my project? My project is in C#.\r\n
-
Is it possible to disable the network in iOS Simulator?
tags: iphone, debugging, ios, ios-simulator
275 votes, 17 answers and 126317 views
\r\n I am trying to debug some inconsistent behaviour I am seeing in an application that gets its primary data from the internet. I don't see the issues in the simulator, just on the device, so I'd like ...\r\n
-
tags: php, arrays, json
261 votes, 9 answers and 382285 views
\r\n I am trying to decode a JSON string into an array but i get the following error.\r\n Fatal error: Cannot use object of type\n stdClass as array in\n C:\wamp\www\temp\asklaila.php on line\n 6\r\nHere is ...\r\n
-
Asking the user for input until they give a valid response
tags: python, validation, loops, python-3.x, user-input
295 votes, 10 answers and 177713 views
\r\n I am writing a program that must accept input from the user.\n\n#note: Python 2.7 users should use
raw_input
, the equivalent of 3.X'sinput
\nage = int(input("Please enter your age: "))\nif age >= ...\r\n -
How do I find duplicate values in a table in Oracle?
tags: sql, oracle, duplicate-data
198 votes, 11 answers and 511830 views
\r\n What's the simplest SQL statement that will return the duplicate values for a given column and the count of their occurrences in an Oracle database table?\n\nFor example: I have a JOBS table with the ...\r\n
-
Meaning of @classmethod and @staticmethod for beginner?
tags: python, oop, static-methods, class-method
1020 votes, 10 answers and 382764 views
\r\n Could someone explain to me the meaning of @classmethod and @staticmethod in python? I need to know the difference and the meaning. \n\nAs far as I understand, @classmethod tells a class that it's a ...\r\n