    &gt;&gt;&gt; a = &#39;1,000,000&#39;
    &gt;&gt;&gt; int(a.replace(&#39;,&#39;, &#39;&#39;))
    1000000
    &gt;&gt;&gt; 

There&#39;s also a simple way to do this that should handle internationalization issues as well:

    &gt;&gt;&gt; import locale
    &gt;&gt;&gt; locale.setlocale(locale.LC_ALL, &#39;en_US.UTF-8&#39;)
    &#39;en_US.UTF-8&#39;
    &gt;&gt;&gt; locale.atoi(&quot;1,000,000&quot;)
    1000000
    &gt;&gt;&gt; 

I found that I have to explicitly set the locale first as above, otherwise it doesn&#39;t work for me and I end up with an ugly traceback instead:

    Traceback (most recent call last):
      File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;
      File &quot;/usr/lib/python2.6/locale.py&quot;, line 296, in atoi
        return atof(str, int)
      File &quot;/usr/lib/python2.6/locale.py&quot;, line 292, in atof
        return func(string)
    ValueError: invalid literal for int() with base 10: &#39;1,000,000&#39;

Replace the &#39;,&#39; with &#39;&#39; and then cast the whole thing to an integer.

    &gt;&gt;&gt; int(&#39;1,000,000&#39;.replace(&#39;,&#39;,&#39;&#39;))
    1000000



I have a table in pg like so:

    CREATE TABLE t (
        a BIGSERIAL NOT NULL,               -- 8 b
        b SMALLINT,                         -- 2 b
        c SMALLINT,                         -- 2 b
        d REAL,                             -- 4 b
        e REAL,                             -- 4 b
        f REAL,                             -- 4 b
        g INTEGER,                          -- 4 b
        h REAL,                             -- 4 b
        i REAL,                             -- 4 b
        j SMALLINT,                         -- 2 b
        k INTEGER,                          -- 4 b
        l INTEGER,                          -- 4 b
        m REAL,                             -- 4 b
        CONSTRAINT a_pkey PRIMARY KEY (a)
    );
    
The above adds up to 50 bytes per row. My experience is that I need another 40% to 50% for system overhead, without even any user-created indexes to the above. So, about 75 bytes per row. I will have many, many rows in the table, potentially upward of 145 billion rows, so the table is going to be pushing 13-14 terabytes. What tricks, if any, could I use to compact this table? My possible ideas below ...

Convert the `real` values to `integer`. If they can stored as `smallint`, that is a saving of 2 bytes per field.

Convert the columns b .. m into an array. I don&#39;t need to search on those columns, but I do need to be able to return one column&#39;s value at a time. So, if I need column g, I could do something like

    SELECT a, arr[5] FROM t;
    
Would I save space with the array option? Would there be a speed penalty?

Any other ideas?

Calculating and saving space in PostgreSQL

I&#39;ve been using SVN for all my projects.
Sometimes project B is originating as a copy from project A.
When project A has a generic change, I can use `svn merge A` within directory B and it will merge those changes.

Now, if I wanted to use git. I don&#39;t like having all my projects in the same repository since I then have to clone *everything* and can&#39;t pick just one project like in SVN.
But having one repository for each project, how do I go about doing the same like I did earlier with SVN?

**The question is:**
What&#39;s the best way to structure it if I want several subprojects that really all relates to one original project and to keep them in sync? And that I also want to be able to check them out separately

git merge different repositories?

How would I parse the string `1,000,000` (one million) into it&#39;s integer value in Python?

Python parse comma-separated number into int

<p>How would I parse the string <code>1,000,000</code> (one million) into it's integer value in Python?</p>


What is the best way to represent a Windows directory, for example `&quot;C:\meshes\as&quot;`? I have been trying to modify a script but it never works because I can&#39;t seem to get the directory right, I assume because of the `&#39;\&#39;` acting as escape character?

Windows path in Python

I am trying to &#39;destructure&#39; a dictionary and associate values with variables names after its keys. Something like

    params = {&#39;a&#39;:1,&#39;b&#39;:2}
    a,b = params.values()

But since dictionaries are not ordered, there is no guarantee that `params.values()` will return values in the order of `(a, b)`. Is there a nice way to do this?

Destructuring-bind dictionary contents

I seem to have a hard time getting my head around this.

What&#39;s the difference between `calendar.timegm()` and `time.mktime()`?

Say I have a `datetime.datetime` with no tzinfo attached, shouldn&#39;t the two give the same output? Don&#39;t they both give the number of seconds between epoch and the date passed as a parameter? And since the date passed has no tzinfo, isn&#39;t that number of seconds the same?

    &gt;&gt;&gt; import calendar
    &gt;&gt;&gt; import time
    &gt;&gt;&gt; import datetime
    &gt;&gt;&gt; d = datetime.datetime(2010, 10, 10)
    &gt;&gt;&gt; calendar.timegm(d.timetuple())
    1286668800
    &gt;&gt;&gt; time.mktime(d.timetuple())
    1286640000.0
    &gt;&gt;&gt; 

Python - calendar.timegm() vs. time.mktime()

I am trying to make 2 functions run at the same time.

    def func1():
        print &#39;Working&#39;

    def func2():
        print &#39;Working&#39;

    func1()
    func2()



Does anyone know how to do this?

Make 2 functions run at the same time

I was trying to normalize a set of numbers from -100 to 0 to a range of 10-100 and was having problems only to notice that even with no variables at all, this does not evaluate the way I would expect it to:

    &gt;&gt;&gt; (20-10) / (100-10)
    0

Float division doesn&#39;t work either:

    &gt;&gt;&gt; float((20-10) / (100-10))
    0.0

If either side of the division is cast to a float it will work:

    &gt;&gt;&gt; (20-10) / float((100-10))
    0.1111111111111111

Each side in the first example is evaluating as an int which means the final answer will be cast to an int. Since 0.111 is less than .5, it rounds to 0.  It is not transparent in my opinion, but I guess that&#39;s the way it is.

What is the explanation?


Why does the division get rounded to an integer?

What is the difference between `parseInt(string)` and `Number(string)` in JavaScript?

What is the difference between parseInt(string) and Number(string) in JavaScript?

How can we convert a JavaScript string variable to decimal?

Is there a function such as: 

    parseInt(document.getElementById(amtid4).innerHTML)

convert a JavaScript string variable to decimal/money

What is a function in PHP used to convert array to string, other than using JSON?

I know there is a function that directly does like JSON. I just don&#39;t remember.

How to convert array to a string using methods other than JSON?

I am working on an Android application. In my app I have to convert a string to JSON Object, then parse the values. I checked for a solution in Stackoverflow and found similar issue here [link][1]


  [1]: https://stackoverflow.com/questions/5245840/how-to-convert-string-to-jsonobject-in-java
  
  The solution is like this

           `{&quot;phonetype&quot;:&quot;N95&quot;,&quot;cat&quot;:&quot;WP&quot;}`
            JSONObject jsonObj = new JSONObject(&quot;{\&quot;phonetype\&quot;:\&quot;N95\&quot;,\&quot;cat\&quot;:\&quot;WP\&quot;}&quot;);

I use the same way in my code . My string is 

    {&quot;ApiInfo&quot;:{&quot;description&quot;:&quot;userDetails&quot;,&quot;status&quot;:&quot;success&quot;},&quot;userDetails&quot;:{&quot;Name&quot;:&quot;somename&quot;,&quot;userName&quot;:&quot;value&quot;},&quot;pendingPushDetails&quot;:[]}

    string mystring= mystring.replace(&quot;\&quot;&quot;, &quot;\\\&quot;&quot;);
    

And after replace I got the result as this

    {\&quot;ApiInfo\&quot;:{\&quot;description\&quot;:\&quot;userDetails\&quot;,\&quot;status\&quot;:\&quot;success\&quot;},\&quot;userDetails\&quot;:{\&quot;Name\&quot;:\&quot;Sarath Babu\&quot;,\&quot;userName\&quot;:\&quot;sarath.babu.sarath babu\&quot;,\&quot;Token\&quot;:\&quot;ZIhvXsZlKCNL6Xj9OPIOOz3FlGta9g\&quot;,\&quot;userId\&quot;:\&quot;118\&quot;},\&quot;pendingPushDetails\&quot;:[]}

when I execute `JSONObject jsonObj = new JSONObject(mybizData);`

I am getting the below JSON exception

&gt; org.json.JSONException: Expected literal value at character 1 of

Please help me to solve my issue.




conversion from string to JSON object Android

In C++ standard library there are functions to convert from string to numeric types:
```
stoi
stol
stoll
stoul
stoull
stof
stod
stold
```
but I find it tedious to use them in template code. Why there are no template functions something like:

```
template&lt;typename T&gt;
T sto(...)
```

to convert strings to numeric types?

I don&#39;t see any technical reason to not have them, but maybe I&#39;m missing something. They can be specialised to call the underlying named functions and use ```enable_if```/```concepts``` to disable non numeric types.

Are there any template friendly alternatives in the standard library to convert string to numeric types and the other way around in an efficient way? 

Content Type	Original Author	Original Content on Stackoverflow
Question	roryf	View Question on Stackoverflow
Solution 1 - Python	joaquin	View Answer on Stackoverflow
Solution 2 - Python	Khorkrak	View Answer on Stackoverflow
Solution 3 - Python	jathanism	View Answer on Stackoverflow

Python parse comma-separated number into int

Python Problem Overview

Python Solutions

Solution 1 - Python

Solution 2 - Python

Solution 3 - Python

git merge different repositories?

Calculating and saving space in PostgreSQL

Attributions