According to the [docs](http://stanford.edu/~mwaskom/software/seaborn/generated/seaborn.heatmap.html#seaborn.heatmap), the param `fmt=&#39;.2g&#39;` is being applied because you&#39;ve set `annot=True` so you can modify the format being applied to:

    sns.heatmap(table2,annot=True,cmap=&#39;Blues&#39;, fmt=&#39;g&#39;)

According to the [docs](https://seaborn.pydata.org/generated/seaborn.heatmap.html), the parameter ```fmt``` is set to ```.2g``` when ```annot=True```. So, for example, if your data is ```float```, you can use:

```
sns.heatmap(table2, annot=True, cmap=&#39;Blues&#39;, fmt=&#39;.3g&#39;)
```

By that, you&#39;re telling python to show 3 significant figures. To understand the &quot;fmt&quot; better, check out this answer: https://stackoverflow.com/a/65020192/4529605


Since there is no `JavaScriptSerializer`, what native implementation can be used to handle this?

I noticed `JsonResult` and I can format data to JSON with this, but how do I deserialize?

Or maybe I am missing some dependencies in `project.json`?


JSON serialization/deserialization in ASP.Net Core

Google Tag Manager told me to put this underneath the opening `body` tag.

&lt;!-- language: lang-html --&gt;

    &lt;!-- Google Tag Manager --&gt;
    &lt;noscript&gt;&lt;iframe src=&quot;//www.googletagmanager.com/ns.html?id=GTM-XXXXXX&quot;
    height=&quot;0&quot; width=&quot;0&quot; style=&quot;display:none;visibility:hidden&quot;&gt;&lt;/iframe&gt;&lt;/noscript&gt;
    &lt;script&gt;(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({&#39;gtm.start&#39;:
    new Date().getTime(),event:&#39;gtm.js&#39;});var f=d.getElementsByTagName(s)[0],
    j=d.createElement(s),dl=l!=&#39;dataLayer&#39;?&#39;&amp;l=&#39;+l:&#39;&#39;;j.async=true;j.src=
    &#39;//www.googletagmanager.com/gtm.js?id=&#39;+i+dl;f.parentNode.insertBefore(j,f);
    })(window,document,&#39;script&#39;,&#39;dataLayer&#39;,&#39;GTM-XXXXXX&#39;);&lt;/script&gt;
    &lt;!-- End Google Tag Manager --&gt;

Now I&#39;m getting this 404 not found for GET:

    GET http://www.googletagmanager.com/gtm.js?id=GTM-XXXXXX

I implemented the code last night. Does this just take time or is this something that needs to be fixed? If the latter, how would I fix it?

404 error for Google Tag Manager

I&#39;m creating a heatmap from a pandas pivot_table as below:

    table2 = pd.pivot_table(df,values=&#39;control&#39;,columns=&#39;Year&#39;,index=&#39;Region&#39;,aggfunc=np.sum)
    sns.heatmap(table2,annot=True,cmap=&#39;Blues&#39;)

It creates a heat map as shown below. You can see the numbers are not huge (max 750), but it&#39;s showing them in scientific notation. If I view the table itself this is not the case. Any idea on how I could get it to show the numbers in plain notation?

![Heatmap][1]


  [1]: http://i.stack.imgur.com/iE5eh.png

Seaborn showing scientific notation in heatmap for 3-digit numbers

I'm creating a heatmap from a pandas pivot_table as below:
<pre><code class="hljs language-ini">table2 = pd.pivot_table(df,values='control',columns='Year',index='Region',aggfunc=np.sum)
sns.heatmap(table2,annot=True,cmap='Blues')
</code></pre>
It creates a heat map as shown below. You can see the numbers are not huge (max 750), but it's showing them in scientific notation. If I view the table itself this is not the case. Any idea on how I could get it to show the numbers in plain notation?
<img src="http://i.stack.imgur.com/iE5eh.png" alt="Heatmap">

    a = {&#39;a&#39;, &#39;b&#39;, &#39;c&#39;} 
    b = {&#39;d&#39;, &#39;e&#39;, &#39;f&#39;}

I want to add above two set values. I need output like

    c = {&#39;a&#39;, &#39;b&#39;, &#39;c&#39;, &#39;d&#39;, &#39;e&#39;, &#39;f&#39;}




How do I add two sets?

How can I convert `Gregorian date` to `Persian date` and vice-versa in `Python`?

[All I found][1] was some widgets and stuffs which will create Persian Calendar. I don&#39;t want a Persian calendar. I just want to convert dates to each other.
So how can I do that?


  [1]: https://github.com/behzadi/persianDatepicker

Convert Gregorian (Christian) date to Persian date and vice-versa in Python

I have a numpy array where each cell of a specific row represents a value for a feature. I store all of them in an 100*4 matrix.

    A     B   C
    1000  10  0.5
    765   5   0.35
    800   7   0.09  

Any idea how I can normalize rows of this numpy.array where each value is between 0 and 1?

My desired output is:

    A     B    C
    1     1    1
    0.765 0.5  0.7
    0.8   0.7  0.18(which is 0.09/0.5)

Thanks in advance :)
 

Normalize numpy array columns in python

I have a Python (2.7) app which is started in my dockerfile:

    CMD [&quot;python&quot;,&quot;main.py&quot;]

*main.py* prints some strings when it is started and goes into a loop afterwards:

    print &quot;App started&quot;
    while True:
        time.sleep(1)

As long as I start the container with the -it flag, everything works as expected:

    $ docker run --name=myapp -it myappimage
    &gt; App started

And I can see the same output via logs later:

    $ docker logs myapp
    &gt; App started

If I try to run the same container with the -d flag, the container seems to start normally, but I can&#39;t see any output:

    $ docker run --name=myapp -d myappimage
    &gt; b82db1120fee5f92c80000f30f6bdc84e068bafa32738ab7adb47e641b19b4d1
    $ docker logs myapp
    $ (empty)

But the container still seems to run;

    $ docker ps
    Container Status ...
    myapp     up 4 minutes ... 

Attach does not display anything either:

    $ docker attach --sig-proxy=false myapp
    (working, no output)

Any ideas whats going wrong? Does &quot;print&quot; behave differently when ran in background?

Docker version:

    Client version: 1.5.0
    Client API version: 1.17
    Go version (client): go1.4.2
    Git commit (client): a8a31ef
    OS/Arch (client): linux/arm
    Server version: 1.5.0
    Server API version: 1.17
    Go version (server): go1.4.2
    Git commit (server): a8a31ef


Python app does not print anything when running detached in docker

Take a look at this:

    $ pypy ./manage.py syncdb
    /usr/lib64/pypy-2.4.0/site-packages/django/core/management/commands/syncdb.py:24: RemovedInDjango19Warning: The syncdb command will be removed in Django 1.9
      warnings.warn(&quot;The syncdb command will be removed in Django 1.9&quot;, RemovedInDjango19Warning)
    
    (cut)

I ran a [quick google search][1], but could not find the answer - what should I be using instead of `syncdb`?

  [1]: https://encrypted.google.com/search?q=django%20syncdb%201.9

What should I use instead of syncdb in Django 1.9?

I am trying to get the following script to work. The input file consists of 3 columns: gene association type, gene name, and disease name.

    cols = [&#39;Gene type&#39;, &#39;Gene name&#39;, &#39;Disorder name&#39;]
    no_headers = pd.read_csv(&#39;orphanet_infoneeded.csv&#39;, sep=&#39;,&#39;,header=None,names=cols)

    gene_type = no_headers.iloc[1:,[0]]
    gene_name = no_headers.iloc[1:,[1]]
    disease_name = no_headers.iloc[1:,[2]]

    query = &#39;Disease-causing germline mutation(s) in&#39; ###add query as required

    orph_dict = {}

    for x in gene_name:
        if gene_name[x] in orph_dict:
            if gene_type[x] == query:
                orph_dict[gene_name[x]]=+ 1
            else:
                pass
        else:
            orph_dict[gene_name[x]] = 0

I keep getting an error that says:

&gt; Series objects are mutable and cannot be hashed

Any help would be dearly appreciated!

&quot;Series objects are mutable and cannot be hashed&quot; error

I have a dataframe with ca 155,000 rows and 12 columns.
If I export it to csv with dataframe.to_csv , the output is an 11MB file (which is produced instantly).

If, however, I export to a Microsoft SQL Server with the to_sql method, it takes between 5 and 6 minutes!
No columns are text: only int, float, bool and dates. I have seen cases where ODBC drivers set nvarchar(max) and this slows down the data transfer, but it cannot be the case here.

Any suggestions on how to speed up the export process? Taking 6 minutes to export 11 MBs of data makes the ODBC connection practically unusable.

Thanks!

My code is:

    import pandas as pd
    from sqlalchemy import create_engine, MetaData, Table, select
    ServerName = &quot;myserver&quot;
    Database = &quot;mydatabase&quot;
    TableName = &quot;mytable&quot;
    
    engine = create_engine(&#39;mssql+pyodbc://&#39; + ServerName + &#39;/&#39; + Database)
    conn = engine.connect()
    
    metadata = MetaData(conn)
    
    my_data_frame.to_sql(TableName,engine)


python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?

I have a dataframe look like this:

    import pandas
    import numpy as np
    df = DataFrame(np.random.rand(4,4), columns = list(&#39;abcd&#39;))
    df
          a         b         c         d
    0  0.418762  0.042369  0.869203  0.972314
    1  0.991058  0.510228  0.594784  0.534366
    2  0.407472  0.259811  0.396664  0.894202
    3  0.726168  0.139531  0.324932  0.906575

How I can get all columns except `column b`?


How to select all columns, except one column in pandas?

I have a dataframe like this one:

    In [10]: df
    Out[10]: 
             Column 1
    foo              
    Apples          1
    Oranges         2
    Puppies         3
    Ducks           4

How to remove `index name` `foo` from that dataframe?
The desired output is like this:


    In [10]: df
    Out[10]: 
             Column 1             
    Apples          1
    Oranges         2
    Puppies         3
    Ducks           4

Remove index name in pandas

I have a dataframe &#39;gt&#39; like this:

    org     group
    org1      1
    org2      1
    org3      2
    org4      3
    org5      3
    org6      3

and I would like to add column &#39;count&#39; to gt dataframe to counts number member of the groups, expected results like this:

    org     group   count
    org1      1       2
    org2      1       2
    org3      2       1
    org4      3       3
    org5      3       3
    org6      3       3

I know how to do it per one item of the group, but do not know how to make the count repeated for all of the group items, here is the code I have used: 

    gtcounts = gt.groupby(&#39;group&#39;).count()

Can anybody help?

Python pandas: Add a column to my dataframe that counts a variable

For a project, I need to know the current size (in pixels) of my matplotlib figure, but I can&#39;t find how to do this.
Does anyone know how to do this ?

How to get matplotlib figure size

I can remove the ticks with

    ax.set_xticks([]) 
    ax.set_yticks([]) 

but this removes the labels as well. Any way I can plot the tick labels but not the ticks and the spine

Python hide ticks but show tick labels

I have a simple stacked line plot that has exactly the date format I want magically set when using the following code.

    df_ts = df.resample(&quot;W&quot;, how=&#39;max&#39;)
    df_ts.plot(figsize=(12,8), stacked=True)

![enter image description here][1]

However, the dates mysteriously transform themselves to an ugly and unreadable format when plotting the same data as a bar plot.

    df_ts = df.resample(&quot;W&quot;, how=&#39;max&#39;)
    df_ts.plot(kind=&#39;bar&#39;, figsize=(12,8), stacked=True)

![enter image description here][2]


The original data was transformed a bit to have the weekly max. Why is this radical change in automatically set dates happening? How can I have the nicely formatted dates as above?

Here is some dummy data

    start = pd.to_datetime(&quot;1-1-2012&quot;)
    idx = pd.date_range(start, periods= 365).tolist()
    df=pd.DataFrame({&#39;A&#39;:np.random.random(365), &#39;B&#39;:np.random.random(365)})
    df.index = idx
    df_ts = df.resample(&#39;W&#39;, how= &#39;max&#39;)
    df_ts.plot(kind=&#39;bar&#39;, stacked=True)

  [1]: http://i.stack.imgur.com/zpCiH.png
  [2]: http://i.stack.imgur.com/8133P.png

Pandas bar plot changes date format

I generated a bar plot, how can I display the value of the bar on each bar?

Current plot:

![enter image description here][1]


What I am trying to get:

![enter image description here][2]


My code:

    import os
    import numpy as np
    import matplotlib.pyplot as plt
            
    x = [u&#39;INFO&#39;, u&#39;CUISINE&#39;, u&#39;TYPE_OF_PLACE&#39;, u&#39;DRINK&#39;, u&#39;PLACE&#39;, u&#39;MEAL_TIME&#39;, u&#39;DISH&#39;, u&#39;NEIGHBOURHOOD&#39;]
    y = [160, 167, 137, 18, 120, 36, 155, 130]
    
    fig, ax = plt.subplots()    
    width = 0.75 # the width of the bars 
    ind = np.arange(len(y))  # the x locations for the groups
    ax.barh(ind, y, width, color=&quot;blue&quot;)
    ax.set_yticks(ind+width/2)
    ax.set_yticklabels(x, minor=False)
    plt.title(&#39;title&#39;)
    plt.xlabel(&#39;x&#39;)
    plt.ylabel(&#39;y&#39;)      
    #plt.show()
    plt.savefig(os.path.join(&#39;test.png&#39;), dpi=300, format=&#39;png&#39;, bbox_inches=&#39;tight&#39;) # use format=&#39;svg&#39; or &#39;pdf&#39; for vectorial pictures


  [1]: http://i.stack.imgur.com/8QhzO.png
  [2]: http://i.stack.imgur.com/yU7lZ.png

How to display the value of the bar on each bar with pyplot.barh()

I would like to create a time series plot using `seaborn.tsplot` like in [this example from `tsplot` documentation][1], but with the legend moved to the right, outside the figure.

![example][2]

Based on the lines 339-340 in [seaborn&#39;s timeseries.py][4], it looks like `seaborn.tsplot` currently doesn&#39;t allow direct control of legend placement:

        if legend:
            ax.legend(loc=0, title=legend_name)

Is there a matplotlib workaround?
I&#39;m using seaborn 0.6-dev.

  [1]: http://stanford.edu/~mwaskom/software/seaborn-dev/examples/timeseries_from_dataframe.html
  [2]: http://i.stack.imgur.com/eBdiz.png
  [4]: https://github.com/mwaskom/seaborn/blob/master/seaborn/timeseries.py &quot;timeseries.py&quot;

Move legend outside figure in seaborn tsplot

How do I add a title to this Seaborne plot? Let&#39;s give it a title &#39;I AM A TITLE&#39;.

    tips = sns.load_dataset(&quot;tips&quot;)
    g = sns.FacetGrid(tips, col=&quot;sex&quot;, row=&quot;smoker&quot;, margin_titles=True)
    g.map(sns.plt.scatter, &quot;total_bill&quot;, &quot;tip&quot;)


![plot][1]


  [1]: http://i.stack.imgur.com/Bk0na.png

How to add a title to Seaborn Facet Plot

I am trying to get a grouped boxplot working using Seaborn as per the [example][1]

I can get the above example working, however the line:

    tips = sns.load_dataset(&quot;tips&quot;)

is not explained at all.  I have located the tips.csv file, but I can&#39;t seem to find adequate documentation on what load_dataset specifically does.  I tried to create my own csv and load this, but to no avail.  I also renamed the tips file and it still worked... 

My question is thus:

Where is `load_dataset` actually looking for files? Can I actually use this for my own boxplots? 

EDIT: I managed to get my own boxplots working using my own `DataFrame`, but I am still wondering whether `load_dataset` is used for anything more than mysterious tutorial examples.

  [1]: http://stanford.edu/~mwaskom/software/seaborn/examples/grouped_boxplot.html

Seaborn load_dataset

I&#39;m trying to plot a ROC curve using seaborn (python).
With matplotlib I simply use the function `plot`:

    plt.plot(one_minus_specificity, sensitivity, &#39;bs--&#39;)

where `one_minus_specificity` and `sensitivity` are two lists of paired values.

Is there a simple counterparts of the plot function in seaborn? I had a look at the gallery but I didn&#39;t find any straightforward method.

Simple line plots using seaborn

How do I change the size of my image so it&#39;s suitable for printing?

For example, I&#39;d like to use to A4 paper, whose dimensions are 11.7 inches by 8.27 inches in landscape orientation.

Content Type	Original Author	Original Content on Stackoverflow
Question	cigrainger	View Question on Stackoverflow
Solution 1 - Python	EdChum	View Answer on Stackoverflow
Solution 2 - Python	Gobryas	View Answer on Stackoverflow

Seaborn showing scientific notation in heatmap for 3-digit numbers

Python Problem Overview

Python Solutions

Solution 1 - Python

Solution 2 - Python

404 error for Google Tag Manager

JSON serialization/deserialization in ASP.Net Core

Attributions