[Running the Django Development Server][1]   
This is what you&#39;re looking for. To help you further, here is what you should do:   

    python manage.py runserver 0.0.0.0:8000

By the way, this may be a duplicate of [this][2] question.

Here is what the documentation says:   

&gt; Note that the default IP address, 127.0.0.1, is not accessible from
&gt; other machines on your network. To make your development server
&gt; viewable to other machines on the network, use its own IP address
&gt; (e.g. 192.168.2.1) or 0.0.0.0.


  [1]: https://docs.djangoproject.com/en/2.0/ref/django-admin/#runserver
  [2]: https://stackoverflow.com/questions/2260727/accessing-local-django-webserver-from-outside-world

To add to @Depado &#39;s answer you may need to add your LAN IP address to `ALLOWED_HOSTS` in the  `settings.py` along with  `localhost`. it would look like,

    ALLOWED_HOSTS = [&quot;localhost&quot;, &quot;192.168.8.160&quot;]

(if `localhost` isn&#39;t working use `127.0.0.1` as suggested by @Sabito 錆兎)

You can use https://ngrok.com/ this will expose your local web server to the internet/public.

Everywhere I looked, I kept seeing the answer to use the terminal command:

`python manage.py runserver 0.0.0.0:8000`

That works, but not if you want to run a remote debugger across the LAN (in my case VSCode), which launches the server automatically without a chance to modify the host ip address. However, I found a permanent solution:

Open: `./env/lib/python3.8/site-packages/django/core/management/commands/runserver.py`

Search for: `self.addr = &#39;&#39;`

Replace `&#39;&#39;` with `&#39;0&#39;` and save. *(`&#39;0&#39;` is shorthand for `&#39;0.0.0.0&#39;`)*

Now if you run: `python manage.py runserver` it is open to the local network, outputting: `Starting development server at http://0:8000/`

Importantly, the debugger now launches the server at `http://0:8000/`

If you haven&#39;t already, remember to add your client to allowed hosts in settings.py: `ALLOWED_HOSTS = [&quot;*&quot;]`

&gt; Blockquote



I have a formula in Excel that needs to be run on several rows of a column based on the numbers in that row divided by one constant. When I copy that formula and apply it to every cell in the range, all of the cell numbers increment with the row, including the constant. So:

    B1=127
    C4=&#39;=IF(B4&lt;&gt;&quot;&quot;,B4/B1,&quot;&quot;)&#39;

If I copy cell C4 and paste it down column C, the formula becomes

    =IF(B5&lt;&gt;&quot;&quot;,B5/B2,&quot;&quot;)
    =IF(B6&lt;&gt;&quot;&quot;,B6/B3,&quot;&quot;)
    etc.

when what I need it to be is 

    =IF(B5&lt;&gt;&quot;&quot;,B5/B1,&quot;&quot;)
    =IF(B6&lt;&gt;&quot;&quot;,B6/B1,&quot;&quot;)
    etc.

Is there a simple way to prevent the expression from incrementing?

Prevent cell numbers from incrementing in a formula in Excel

My goal:

Display a dialog box prompting the user to save a file being downloaded from aws.

My problem:

I am currently using awssum-amazon-s3 to create a download stream. However I&#39;ve only managed to save the file to my server or stream it to the command line... As you can see from my code my last attempt was to try and manually set the content disposition headers which failed. I cannot use res.download() as the headers have already been set?

How can I achieve my goal?

My code for node:

    app.post(&#39;/dls/:dlKey&#39;, function(req, res, next){
    		// download the file via aws s3 here
    		var dlKey = req.param(&#39;dlKey&#39;);
    
    		Dl.findOne({key:dlKey}, function(err, dl){
    			if (err) return next(err);
    			var files = dl.dlFile;
    
    			var options = {
    				BucketName    : &#39;xxxx&#39;,
    				ObjectName    : files,
    			};
    
    			s3.GetObject(options, { stream : true }, function(err, data) {
    				// stream this file to stdout
    				fmt.sep();
    				data.Headers[&#39;Content-Disposition&#39;] = &#39;attachment&#39;;
    				console.log(data.Headers);
    				data.Stream.pipe(fs.createWriteStream(&#39;test.pdf&#39;));
    				data.Stream.on(&#39;end&#39;, function() {
    					console.log(&#39;File Downloaded!&#39;);
    				});
    			});
    		});
    
    		res.end(&#39;Successful Download Post!&#39;);
    	});

My code for angular:

    $scope.dlComplete = function (dl) {
            $scope.procDownload = true;
            $http({
                method: &#39;POST&#39;,
                url: &#39;/dls/&#39; + dl.dlKey
            }).success(function(data/*, status, headers, config*/) {
                console.log(data);
                $location.path(&#39;/#!/success&#39;);
            }).error(function(/*data, status, headers, config*/) {
                console.log(&#39;File download failed!&#39;);
            });
        };

The purpose of this code it to let users use a generated key to download a file once.


NodeJS How do I Download a file to disk from an aws s3 bucket?

I have installed Django server and it can be accessed as below

    http://localhost:8000/get-sms/
    http://127.0.0.1:8000/get-sms/

suppose My IP is `x.x.x.x` . 

From another PC under the same network when I do

```
my-ip:8000/get-sms/
```
but it is not working. 

I can easily ping my IP with that computer.

Moreover, on my port 81, I have apache, which is easily accessible like below

    http:///my-ip:81


What can be the issue? Do I need something extra in Django


Making django server accessible in LAN

I have installed Django server and it can be accessed as below
<pre><code class="hljs language-vbnet">http://localhost:8000/get-sms/
http://127.0.0.1:8000/get-sms/
</code></pre>
suppose My IP is <code>x.x.x.x</code> .
From another PC under the same network when I do
<pre><code class="hljs language-arduino">my-ip:8000/get-sms/
</code></pre>
but it is not working.
I can easily ping my IP with that computer.
Moreover, on my port 81, I have apache, which is easily accessible like below
<pre><code class="hljs language-perl">http:///my-ip:81
</code></pre>
What can be the issue? Do I need something extra in Django

Here is my code to generate a dataframe:

    import pandas as pd
    import numpy as np

    dff = pd.DataFrame(np.random.randn(1,2),columns=list(&#39;AB&#39;))

then I got the dataframe:

    +------------+---------+--------+
    |            |  A      |  B     |
    +------------+---------+---------
    |      0     | 0.626386| 1.52325|
    +------------+---------+--------+
When I type the commmand :
 
    dff.mean(axis=1)
I got :

    0    1.074821
    dtype: float64
According to the reference of pandas, axis=1 stands for columns and I expect the result of the command to be

    A    0.626386
    B    1.523255
    dtype: float64
So here is my question: what does axis in pandas mean?


What does axis in pandas mean?

I&#39;ve an Excel File:

    Arm_id	    DSPName	       DSPCode	        HubCode	         PinCode	PPTL
    1	         JaVAS	          01	          AGR	          282001	1,2
    2	         JaVAS	          01	          AGR	          282002	3,4
    3	         JaVAS	          01	          AGR	          282003	5,6

I want to save a string in the form `Arm_id,DSPCode,Pincode`. This format is configurable, i.e. it might change to `DSPCode,Arm_id,Pincode`. I save it in a list like:

    FORMAT = [&#39;Arm_id&#39;, &#39;DSPName&#39;, &#39;Pincode&#39;]

How do I read the content of a specific column with provided name, given that the `FORMAT` is configurable?

This is what I tried. Currently I&#39;m able to read all the content in the file

    from xlrd import open_workbook
    wb = open_workbook(&#39;sample.xls&#39;)
    for s in wb.sheets():
    	#print &#39;Sheet:&#39;,s.name
    	values = []
    	for row in range(s.nrows):
    		col_value = []
    		for col in range(s.ncols):
    			value  = (s.cell(row,col).value)
    			try : value = str(int(value))
    			except : pass
    			col_value.append(value)
    		values.append(col_value)
    print values

My output is :

    [
        [u&#39;Arm_id&#39;, u&#39;DSPName&#39;, u&#39;DSPCode&#39;, u&#39;HubCode&#39;, u&#39;PinCode&#39;, u&#39;PPTL&#39;],
        [&#39;1&#39;, u&#39;JaVAS&#39;, &#39;1&#39;, u&#39;AGR&#39;, &#39;282001&#39;, u&#39;1,2&#39;], 
        [&#39;2&#39;, u&#39;JaVAS&#39;, &#39;1&#39;, u&#39;AGR&#39;, &#39;282002&#39;, u&#39;3,4&#39;], 
        [&#39;3&#39;, u&#39;JaVAS&#39;, &#39;1&#39;, u&#39;AGR&#39;, &#39;282003&#39;, u&#39;5,6&#39;]
    ]

Then I loop around `values[0]` trying to find out the `FORMAT` content in `values[0]` and then getting the index of `Arm_id, DSPname and Pincode` in the `values[0]` and then from next loop I know the index of all the `FORMAT` factors , thereby getting to know which value do I need to get .

But this is such a poor solution.

**How do I get the values of a specific column with name in excel file?**

Reading Excel File using Python, how do I get the values of a specific column with indicated column name?

What does `for row_number, row in enumerate(cursor):` do in Python?

What does `enumerate` mean in this context?

What does enumerate() mean?

In Matplotlib, I would like to draw a **thick plus sign** (or a cross), but the one provided in the [marker set][1] is too **thin**.

Even as I increase its size, it doesn&#39;t get any thicker.

For [example][2]:
![enter image description here][3]
The [lines of code][4] drawing the red plus sign are:

    # Draw median marker.
    if plot_opts.get(&#39;bean_show_median&#39;, True):
        ax.plot(pos, np.median(pos_data),
                marker=plot_opts.get(&#39;bean_median_marker&#39;, &#39;+&#39;),
                color=plot_opts.get(&#39;bean_median_color&#39;, &#39;r&#39;))

If I add an extra parameter `markersize=20`, the marker will only stretch. It will be as thin as before. Can I make it thick?


  [1]: http://www.loria.fr/~rougier/teaching/matplotlib/#markers
  [2]: http://statsmodels.sourceforge.net/devel/generated/statsmodels.graphics.boxplots.beanplot.html
  [3]: http://i.stack.imgur.com/U1FQw.png
  [4]: http://statsmodels.sourceforge.net/devel/_modules/statsmodels/graphics/boxplots.html

matplotlib: make plus sign thicker

I&#39;m using Alembic with SQL Alchemy. With SQL Alchemy, I tend to follow a pattern where I don&#39;t store the connect string with the versioned code. Instead I have file `secret.py` that contains any confidential information. I throw this filename in my `.gitignore` so it doesn&#39;t end up on GitHub.

This pattern works fine, but now I&#39;m getting into using Alembic for migrations. It appears that I cannot hide the connect string. Instead in alembic.ini, you place the connect string as a [configuration parameter][1]:

    # the &#39;revision&#39; command, regardless of autogenerate
    # revision_environment = false
    
    sqlalchemy.url = driver://user:pass@localhost/dbname
    
    # Logging configuration
    [loggers]
    keys = root,sqlalchemy,alembi

I fear I&#39;m going to accidentally commit a file with username/password information for my database. I&#39;d rather store this connect string in a single place and avoid the risk of accidentally committing it to version control.

What options do I have?

  [1]: http://alembic.readthedocs.org/en/latest/tutorial.html#editing-the-ini-file

Is it possible to store the alembic connect string outside of alembic.ini?

In the Admin console, I can add a group and add a bunch of permissions that relate to my models, e.g.

    api | project | Can add project
    api | project | Can change project
    api | project | Can delete project

How can I do this programmatically. I can&#39;t find any information out there on how to do this.

I have:

    from django.contrib.auth.models import Group, Permission
    from django.contrib.contenttypes.models import ContentType

    from api.models import Project


    new_group, created = Group.objects.get_or_create(name=&#39;new_group&#39;)
    # Code to add permission to group ???
    ct = ContentType.objects.get_for_model(Project)
    # Now what - Say I want to add &#39;Can add project&#39; permission to new_group?


UPDATE: Thanks for the answer you provided. I was able to use that to work out what I needed. In my case, I can do the following: 

    new_group, created = Group.objects.get_or_create(name=&#39;new_group&#39;)
    proj_add_perm = Permission.objects.get(name=&#39;Can add project&#39;)
    new_group.permissions.add(proj_add_perm)

Programmatically create a django group with permissions

I implemented a REST api in django with django-rest-framework and used oauth2 for authentication.

I tested with:

    curl -X POST -d &quot;client_id=YOUR_CLIENT_ID&amp;client_secret=YOUR_CLIENT_SECRET&amp;grant_type=password&amp;username=YOUR_USERNAME&amp;password=YOUR_PASSWORD&quot; http://localhost:8000/oauth2/access_token/

and

    curl -H &quot;Authorization: Bearer &lt;your-access-token&gt;&quot; http://localhost:8000/api/

on localhost with successful results consistent with the documentation.

When pushing this up to an existing AWS elastic beanstalk instance, I received:

    { &quot;detail&quot; : &quot;Authentication credentials were not provided.&quot; }



Authorization Credentials Stripped --- django, elastic beanstalk, oauth

I&#39;ve set up PyCharm, created my virtualenv (either through the virtual env command, or directly in PyCharm) and activated that environment as my Interpreter. Everything is working just fine.

However, if I open a terminal using &quot;Tools, Open Terminal&quot;, the shell prompt supplied is _not_ using the virtual env; I still have to use ```source ~/envs/someenv/bin/activate``` within that Terminal to activate it.

Another method is to activate the environment in a shell, and run PyCharm from that environment. This is &quot;workable&quot; but pretty ugly, and means I have major problems if I switch environments or projects from PyCharm: I&#39;m now using the totally-wrong environment.

Is there some other, much-easier way to have &quot;Tools, Open Terminal&quot; automatically activate the virtual environment?

How do I activate a virtualenv inside PyCharm&#39;s terminal?

In my model, I want a field that has a list of triplets. e.g. `[[1, 3, 4], [4, 2, 6], [8, 12, 3], [3, 3, 9]]`. Is there a field that can store this data in the database?

List field in model?

I&#39;m developing a Phonegap app for my Django based app, but when trying to make Ajax calls I get this error:

    XMLHttpRequest cannot load http://domain.herokuapp.com/getcsrf/?tags=jquery%2Cjavascript&amp;tagmode=any&amp;format=json. No &#39;Access-Control-Allow-Origin&#39; header is present on the requested resource. Origin &#39;null&#39; is therefore not allowed access. 

How can I make it so my Django app allows cross origin for some urls?

Here&#39;s my Ajax code:

    get: function() {
        $.getJSON(&quot;http://domain.herokuapp.com/getcsrf/&quot;,
        {
            tags: &quot;jquery,javascript&quot;,
            tagmode: &quot;any&quot;,
            format: &quot;json&quot;
        },
        function(data) {
            $.each(data.items, function(item){
                console.log(item);
                });
        });
    }


Content Type	Original Author	Original Content on Stackoverflow
Question	sumit	View Question on Stackoverflow
Solution 1 - Python	Depado	View Answer on Stackoverflow
Solution 2 - Python	Achala Dissanayake	View Answer on Stackoverflow
Solution 3 - Python	Venkatesh Bachu	View Answer on Stackoverflow
Solution 4 - Python	Joshua S	View Answer on Stackoverflow

Making django server accessible in LAN

Python Problem Overview

Python Solutions

Solution 1 - Python

Solution 2 - Python

Solution 3 - Python

Solution 4 - Python

NodeJS How do I Download a file to disk from an aws s3 bucket?

Prevent cell numbers from incrementing in a formula in Excel

Attributions