In the new IPython cells could have two states: when it has a green selection rectangle around it you can edit what&#39;s inside; when it has a grey rectangle around it you edit the cell itself (copy/paste/delete). Enter/Return makes it go green, Esc makes it go grey. When it is gray, &#39;dd&#39; will delete it.

To delete a cell, just click on the part margin part of the cell, the part that is not code or output ( right below the Ln[7]: in the picture below), and simply press the `d` key twice. Clicking there selects the entire cell and allows you to use keyboard short cuts like delete and or create a cell above or below.

 [![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/PSpTZ.png

I&#39;ve encountered situations where only glob-style patterns are supported and full regular expression support is not there, for instance redis keys. I&#39;d like to know the distinction between the two. Also it makes me wonder, is implementing regex matching algorithm way harder compared to glob-style pattern that some softwares doesn&#39;t support regex at all?

What are the differences between glob-style pattern and regular expression?

How to provide primary key for multiple column in a single table using PostgreSQL?   

Example:

    Create table &quot;Test&quot; 
    (
       &quot;SlNo&quot; int not null primary key,
       &quot;EmpID&quot; int not null, /* Want to become primary key */
       &quot;Empname&quot; varchar(50) null,
       &quot;EmpAddress&quot; varchar(50) null
    );

Note: I want to make `&quot;EmpID&quot;` also a primary key.

Primary key for multiple column in PostgreSQL?

There is probably a very easy solution to this but I&#39;m not sure what it is. Delete cell command in IPython 1.2 used to be:
 
    ctrl-m d

according to the help menu in version 2.0 it says,

    Shift-d: delete cell(press twice) 

I&#39;ve tried holding `shift` then pressing `d` twice and various combinations with `shift` and `d` and nothing seems to work.. Am I just doing this wrong or the command is actually not working? Any help would be appreciated.

Delete cell ipython 2.0

There is probably a very easy solution to this but I'm not sure what it is. Delete cell command in IPython 1.2 used to be:
<pre><code class="hljs">ctrl-m d
</code></pre>
according to the help menu in version 2.0 it says,
<pre><code class="hljs language-arduino">Shift-d: delete cell(press twice) 
</code></pre>
I've tried holding <code>shift</code> then pressing <code>d</code> twice and various combinations with <code>shift</code> and <code>d</code> and nothing seems to work.. Am I just doing this wrong or the command is actually not working? Any help would be appreciated.

I would like to make the default port that `manage.py runserver` listens on specifiable in an extraneous `config.ini`. Is there an easier fix than parsing `sys.argv` inside `manage.py` and inserting the configured port?

The goal is to run `./manage.py runserver` without having to specify address and port every time but having it take the arguments from the `config.ini`.

django change default runserver port

`ViewSets` have automatic methods to list, retrieve, create, update, delete, ...

I would like to disable some of those, and the solution I came up with is probably not a good one, since `OPTIONS` still states those as allowed.

Any idea on how to do this the right way?

&lt;!-- language: lang-python --&gt;

    class SampleViewSet(viewsets.ModelViewSet):
        queryset = api_models.Sample.objects.all()
        serializer_class = api_serializers.SampleSerializer

        def list(self, request):
            return Response(status=status.HTTP_405_METHOD_NOT_ALLOWED)
        def create(self, request):
            return Response(status=status.HTTP_405_METHOD_NOT_ALLOWED)


Disable a method in a ViewSet, django-rest-framework

First I&#39;m new to pandas, but I&#39;m already falling in love with it.  I&#39;m trying to implement the equivalent of the Lag function from Oracle.

Let&#39;s suppose you have this DataFrame:

    Date                   Group      Data
    2014-05-14 09:10:00        A         1
    2014-05-14 09:20:00        A         2
    2014-05-14 09:30:00        A         3
    2014-05-14 09:40:00        A         4
    2014-05-14 09:50:00        A         5
    2014-05-14 10:00:00        B         1
    2014-05-14 10:10:00        B         2
    2014-05-14 10:20:00        B         3
    2014-05-14 10:30:00        B         4

If this was an oracle database and I wanted to create a lag function grouped by the &quot;Group&quot; column and ordered by the Date I could easily use this function:

     LAG(Data,1,NULL) OVER (PARTITION BY Group ORDER BY Date ASC) AS Data_lagged

This would result in the following Table:

    Date                   Group     Data    Data lagged
    2014-05-14 09:10:00        A        1           Null
    2014-05-14 09:20:00        A        2            1
    2014-05-14 09:30:00        A        3            2
    2014-05-14 09:40:00        A        4            3
    2014-05-14 09:50:00        A        5            4
    2014-05-14 10:00:00        B        1           Null
    2014-05-14 10:10:00        B        2            1
    2014-05-14 10:20:00        B        3            2
    2014-05-14 10:30:00        B        4            3

In pandas I can set the date to be an index and use the shift method:

    db[&quot;Data_lagged&quot;] = db.Data.shift(1)

The only issue is that this doesn&#39;t group by a column.  Even if I set the two columns Date and Group as indexes, I would still get the &quot;5&quot; in the lagged column.

Is there a way to implement the equivalent of the Lead and lag functions in Pandas?


Pandas equivalent of Oracle Lead/Lag function

I know I can write a CSV file with something like:

    with open(&#39;some.csv&#39;, &#39;w&#39;, newline=&#39;&#39;) as f:

How would I instead write that output to `stdout`?

How to write CSV output to stdout?

The `pandas` `drop_duplicates` function is great for &quot;uniquifying&quot; a dataframe. However, one of the keyword arguments to pass is `take_last=True` or `take_last=False`, while I would like to drop all rows which are duplicates across a subset of columns. Is this possible?

		A	B	C
	0	foo 0	A
	1	foo	1	A
	2	foo	1	B
	3	bar 1	A
	
As an example, I would like to drop rows which match on columns `A` and `C` so this should drop rows 0 and 1.

Drop all duplicate rows across multiple columns in Python Pandas

I am very familiar with the Visual Studio IDE, and am new to working with Android Studio. Is there a way to configure Android Studio so that the keyboard shortcuts that I&#39;m used to from Visual Studio can be used in Android Studio?

How can Visual Studio shortcut keys be used in Android Studio?

I&#39;m on a Mac. I have 7 columns in Sublime Text 3, each 300 lines each. If possible, I would like to select only the 4th column using a single keyboard shortcut. 

*Unsuitable options*

- `ctrl` + `shift` + `up/down`
- `alt` + `mouse` + `drag`
- `ctrl` + `alt` + `up/down`. (This actually doesn&#39;t do anything, nor does it appear in my console session and nor is it a single keyboard shortcut).
- I&#39;d also prefer not to use VI/VIM mode just for this as it&#39;s not regular part of my workflow

*What I&#39;ve tried:*

- A macro: but it isn&#39;t specific enough. 
- using `command` and &#39;page down&#39; with `ctrl` and &#39;shift`: no luck
- SublimeText 3 Column-Select plugin: did not seem to work for me

My ideal solution would be that my cursor could be placed anywhere in a column and I would hit a shortcut (e.g. ctrl-alt-shift-a) and it would select the whole column. 

Here is an example:

John  	  	 Sally		Benson	 	 Mariah  	 Patrick  	Samantha	Martin

Simon 	  	 Kate  	 	Carey  		 Delores 	 Joshua    	Samuel 	 	Eliza

I want to select the column with Maria and Delores with one keystroke. I perform this action often so for various reasons (cut/paste, change case, append, add quotes, run macro etc) and thus would want something quick and repeatable.

How would I do this?

Column/Vertical selection with Keyboard in SublimeText 3

**Edit: my system had global key map which had overridden PyCharm.**
Here&#39;s the original question:

I&#39;ve tried these answers, but nothing happened: https://stackoverflow.com/questions/7441541/keyboard-shortcut-for-jump-to-previous-view-location-in-intellij-idea

For example:

1. I&#39;m navigating to a function body,
2. put the cursor on a function call,
3. click &lt;kbd&gt;F12&lt;/kbd&gt; (&quot;go to definition&quot;)
4. from the new location (the function&#39;s body), how do I return to the function call?

I&#39;ve tried these, but they didn&#39;t do anything:

 - &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;Shift&lt;/kbd&gt;+&lt;kbd&gt;Left&lt;/kbd&gt;
 - &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;Shift&lt;/kbd&gt;+&lt;kbd&gt;F2&lt;/kbd&gt;      &lt;-- this is my default mapping 
 - &lt;kbd&gt;Alt&lt;/kbd&gt;+&lt;kbd&gt;Shift&lt;/kbd&gt;+&lt;kbd&gt;Left&lt;/kbd&gt;
 - &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;Shift&lt;/kbd&gt;+&lt;kbd&gt;backspace&lt;/kbd&gt;
 - don&#39;t try that on linux:  &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;Alt&lt;/kbd&gt;+&lt;kbd&gt;backspace&lt;/kbd&gt;

Or maybe &lt;kbd&gt;F12&lt;/kbd&gt; (&quot;go to def&quot;) isn&#39;t &quot;strong enough&quot; to trigger a location-change event?


In PyCharm how to go back to last location?

I&#39;m searching for useful Android Studio keyboard shortcut for commenting code, as in Sublime Text or Eclipse. 


When I press either &lt;kbd&gt;cmd&lt;/kbd&gt;+&lt;kbd&gt;/&lt;/kbd&gt; or &lt;kbd&gt;cmd&lt;/kbd&gt;+&lt;kbd&gt;maj&lt;/kbd&gt;+&lt;kbd&gt;/&lt;/kbd&gt; nothing happens...



Comment shortcut Android Studio

I&#39;m having a problem always when I&#39;m trying to close a window through the `window.close()` method of the Javascript, while the browser displays the below message on the console:

    &quot;Scripts may close only the windows that were opened by it.&quot;

This occurs in every part of the page. I can run this directly of a link, button, or a script, but this message always are displayed.

I&#39;m tried to replace the `window.close();` method for the functions (or variants of these) below, but nothing happened again:

    window.open(&#39;&#39;, &#39;_self&#39;, &#39;&#39;);
    window.close();

window.close() doesn&#39;t work - Scripts may close only the windows that were opened by it

How can output to `stdout` be suppressed?

A semi-colon can be used to supress display of returned objects, for example

    &gt;&gt;&gt; 1+1
    2

    &gt;&gt;&gt; 1+1;   # No output!


However, a function that prints to stdout is not affected by the semi-colon.

    &gt;&gt;&gt; print(&#39;Hello!&#39;)
    Hello!

    &gt;&gt;&gt; MyFunction()
    Calculating values...

How can the output from `print` / `MyFunction` be suppressed?
    

How do you suppress output in Jupyter running IPython?

I&#39;d like to programmatically exit a cell early in IPython Notebook. `exit(0)`, however, kills the kernel. 

Whats the proper way to do this? I&#39;d prefer not to split the cell or manually halt execution. 

IPython Notebook - early exit from cell

In a iPython notebook, I have a while loop that listens to a Serial port and `print` the received data in real time.

What I want to achieve to only show the latest received data (i.e only one line showing the most recent data. no scrolling in the cell output area)

What I need(i think) is to clear the old cell output when I receives new data, and then prints the new data. I am wondering how can I clear old data programmatically ?

ipython notebook clear cell output in code

in `ipython`, I can use `%hist` or `%history` to print recent history, but this only prints history from current session.

I would like to print all history, similar as bash `history`command does. 

What I am trying to do is to get complete history, so that I can then search with regex, see what commands followed after specified commands, and so on

Speaking of history, can it also print timecodes?


**SIDE NOTE**:
In bash, I have written a simple script which prints history and I can grep it for keywords. I see times when certain commands were executed. I can specify `-A n` or `-B n`, where `n` is a number of lines `AFTER` or `BEFORE` a given command.
This is very handy, because I can easily find what I did when, and what followed, ...

I am looking for something similar for `ipython`

ipython: print complete history (not just current session)

I am using `ipython` notebook (http://ipython.org/notebook.html) to do a demo and it seems like the print function is not working:

![enter image description here][1]

The commands in the above picture are rewritten here for clarity.

    In [1]: &#39;hello world&#39;
    Out [1]: &#39;hello world&#39;
    
    In [2]: print &#39;hello world&#39;

In short, there&#39;s no print output from the `[2]`.

Does anyone know whether it&#39;s a known bug? And does anyone know how to fix it?


  [1]: http://i.stack.imgur.com/10NA4.png


Content Type	Original Author	Original Content on Stackoverflow
Question	pbreach	View Question on Stackoverflow
Solution 1 - Python	dmvianna	View Answer on Stackoverflow
Solution 2 - Python	agconti	View Answer on Stackoverflow

Delete cell ipython 2.0

Python Problem Overview

Python Solutions

Solution 1 - Python

Solution 2 - Python

Primary key for multiple column in PostgreSQL?

What are the differences between glob-style pattern and regular expression?

Attributions