This is a known issue introduced with the 2016.2 release. Progress can be followed on the JetBrains website [here][1]. According to this page it is due to be fixed in the 2017.1 release. You can follow the utrunner.py workaround that others have mentioned in the meantime - a copy of this file is attached to the linked ticket.


  [1]: https://youtrack.jetbrains.com/issue/PY-20171

The latest recommendation [(Dec. 19, 2016)][1] is to put this line at the top of your unit test script:

    from __future__ import absolute_import


  [1]: https://youtrack.jetbrains.com/issue/PY-20171

On OS X I&#39;ve fixed this by replacing 

    Applications/PyCharm.app/Contents/helpers/pycharm/utrunner.py 

with an older version that can be found at 
    http://code.metager.de/source/xref/jetbrains/intellij/community/python/helpers/pycharm/utrunner.py




On **Ubuntu 16.04** Bobby&#39;s solution also works:

Just replace your local `utrunner.py` file at 

    /usr/local/pycharm-edu-3.0/helpers/pycharm/utrunner.py

by the one from the Jetbrains website: http://code.metager.de/source/xref/jetbrains/intellij/community/python/helpers/pycharm/utrunner.py 

    


On Windows 10 Bobby&#39;s solution also works:

Just replace your local utrunner.py file at

    C:\Program Files (x86)\JetBrains\PyCharm 2016.3\helpers\pycharm

with the one from the Jetbrains website: http://code.metager.de/source/xref/jetbrains/intellij/community/python/helpers/pycharm/utrunner.py



In my ASP.NET Core (.NET Framework) project, I&#39;m getting above error on my following Controller Action method. What I may be missing? Or, are there any work arounds?:

```C#
public class ClientController : Controller
{
    public ActionResult CountryLookup()
    {
        var countries = new List&lt;SearchTypeAheadEntity&gt;
        {
            new SearchTypeAheadEntity {ShortCode = &quot;US&quot;, Name = &quot;United States&quot;},
            new SearchTypeAheadEntity {ShortCode = &quot;CA&quot;, Name = &quot;Canada&quot;}
        };
        
        return Json(countries, JsonRequestBehavior.AllowGet);
    }
}
```
**UPDATE**: 

 Please note folowing comments from  @NateBarbettini below:

 1. `JsonRequestBehavior` has been deprecated in ASP.NET Core 1.0.
 2. In accepted response from @Miguel below, the `return type` of action method `does not` specifically need to be of type JsonResult. ActionResult or IActionResult works too.

ASP.NET Core - The name &#39;JsonRequestBehavior&#39; does not exist in the current context

When I&#160;updated my packages I&#160;have this new error:

    class TreeBuilderForHtml5lib(html5lib.treebuilders._base.TreeBuilder):
    AttributeError: &#39;module&#39; object has no attribute &#39;_base&#39;

I tried to update `beautifulsoup`, with no more result. How can I&#160;fix that?

beautifulsoup, html5lib:&#160;module object has no attribute _base

After updating to new version 2016.2, I am getting

    RuntimeWarning: Parent module &#39;tests&#39; not found while handling absolute import
      import unittest
    RuntimeWarning: Parent module &#39;tests&#39; not found while handling absolute import
      import datetime as dt

&#39;tests&#39; is a package inside my main app package, and I receive these warnings when I try to execute unit tests inside this folder. This issue only came up after updating to 2016.2. Besides the warnings, the remaining code works fine.

Edit: This is a known issue - https://youtrack.jetbrains.com/issue/PY-20171. They are suggesting to replace utrunner.py in PyCharm installation folder.

Pycharm import RuntimeWarning after updating to 2016.2

After updating to new version 2016.2, I am getting
<pre><code class="hljs language-javascript">RuntimeWarning: Parent module 'tests' not found while handling absolute import
 import unittest
RuntimeWarning: Parent module 'tests' not found while handling absolute import
 import datetime as dt
</code></pre>
'tests' is a package inside my main app package, and I receive these warnings when I try to execute unit tests inside this folder. This issue only came up after updating to 2016.2. Besides the warnings, the remaining code works fine.
Edit: This is a known issue - <a href="https://youtrack.jetbrains.com/issue/PY-20171" target="_blank" rel="noopener noreferrer">https://youtrack.jetbrains.com/issue/PY-20171</a>. They are suggesting to replace utrunner.py in PyCharm installation folder.

`np.where` has the semantics of a vectorized if/else (similar to Apache Spark&#39;s `when`/`otherwise` DataFrame method). I know that I can use `np.where` on `pandas.Series`, but `pandas` often defines its own API to use instead of raw `numpy` functions, which is usually more convenient with `pd.Series`/`pd.DataFrame`.

Sure enough, I found `pandas.DataFrame.where`. However, at first glance, it has completely different semantics. I could not find a way to rewrite the most basic example of `np.where` using pandas `where`:

    # df is pd.DataFrame
    # how to write this using df.where?
    df[&#39;C&#39;] = np.where((df[&#39;A&#39;]&lt;0) | (df[&#39;B&#39;]&gt;0), df[&#39;A&#39;]+df[&#39;B&#39;], df[&#39;A&#39;]/df[&#39;B&#39;])

Am I missing something obvious? Or is pandas&#39; `where` intended for a completely different use case, despite same name as `np.where`? 

pandas equivalent of np.where

I want to get the first match of a regex.

In this case, I have a list:

    text = &#39;aa33bbb44&#39;
    re.findall(&#39;\d+&#39;,text)
&gt;[&#39;33&#39;, &#39;44&#39;]

I could extract the first element of the list:

    text = &#39;aa33bbb44&#39;
    re.findall(&#39;\d+&#39;,text)[0]
&gt; &#39;33&#39;

But that only works if there is at least one match, otherwise I&#39;ll get an error:

    text = &#39;aazzzbbb&#39;
    re.findall(&#39;\d+&#39;,text)[0]

&gt; IndexError: list index out of range

In which case I could define a function:

    def return_first_match(text):
        try:
            result = re.findall(&#39;\d+&#39;,text)[0]
        except Exception, IndexError:
            result = &#39;&#39;
        return result

Is there a way of obtaining that result without defining a new function?

Return string with first match for a regex, handling case where there is no match

I use the following code to create a numpy-ndarray. The file has 9 columns. I explicitly type each column:

    dataset = np.genfromtxt(&quot;data.csv&quot;, delimiter=&quot;,&quot;,dtype=(&#39;|S1&#39;, float, float,float,float,float,float,float,int))

 Now I would like to get some descriptive statistics for each column (min, max, stdev, mean, median, etc.). Shouldn&#39;t there be an easy way to do this?

I tried this:

    from scipy import stats
    stats.describe(dataset)

but this returns an error: `TypeError: cannot perform reduce with flexible type`

How can I get descriptive statistics of the created NumPy array?

How can I get descriptive statistics of a NumPy array?

If the input is zero I want to make an array which looks like this:

    [1,0,0,0,0,0,0,0,0,0]

and if the input is 5:

    [0,0,0,0,0,1,0,0,0,0]

For the above I wrote:

    np.put(np.zeros(10),5,1)

but it did not work.

Is there any way in which, this can be implemented in one line?


One Hot Encoding using numpy

I&#39;m looking at the [WSGI specification][1] and I&#39;m trying to figure out how servers like [uWSGI][2] fit into the picture. I understand the point of the WSGI spec is to separate web servers like nginx from web applications like something you&#39;d write using [Flask][3]. What I don&#39;t understand is what uWSGI is for. Why can&#39;t nginx directly call my Flask application? Can&#39;t flask speak WSGI directly to it? Why does uWSGI need to get in between them?

There are two sides in the WSGI spec: the server and the web app. Which side is uWSGI on?


  [1]: https://en.wikipedia.org/wiki/Web_Server_Gateway_Interface
  [2]: https://uwsgi-docs.readthedocs.io/en/latest
  [3]: http://flask.pocoo.org

What is the point of uWSGI?

Coming from Java to TS, I&#39;ve omitted the `{...}` around the imported type. 

    import DiscriminatorMappingData from &#39;./DiscriminatorMappingData&#39;;

instead of 

    import {DiscriminatorMappingData} from &#39;./DiscriminatorMappingData&#39;;

See https://stackoverflow.com/questions/38715797/typescript-storing-a-class-as-a-map-value?noredirect=1#comment64813552_38715797.

I&#39;ve read the documentation and didn&#39;t understand much. I only took from it that when I only need one type from a file, I can omit the `{}`.  
However, that caused weird errors, like &quot;Unknown name&quot;, or unexpected type incompatibilites.

So, what&#39;s the difference, put simply?

TypeScript - difference between import ... and import {...} (with curly braces)

What is the best way to have a global css file in Vuejs for all components? (Default css like bg color, button styling, etc)

 - import a css file in the index.html
 - do `@import` in main component
 - put all the css in the main component (but that would be a huge file)

Best way to have global css in Vuejs

I have data in an Excel file - actually [XLSX][1] format since it is now 2020. My requirement is to get this data into SQL Server as follows:

 1. ad hoc, the use case being feeding tables with test data, or infrequent data loads of small amounts of data (say &lt; 3k rows), and

 2. In a repeatable, robust, and possibly automated way for a production system.

  [1]: https://en.wikipedia.org/wiki/Microsoft_Excel#Current_file_extensions



How can I import an Excel file into SQL Server?

I&#39;m trying to import a theme from a CSS module but TypeScript gives me a &quot;Cannot Find Module&quot; error and the theme isn&#39;t applied on runtime. I think there&#39;s something wrong with my Webpack config but I&#39;m not sure where the problem is.

I&#39;m using the following tools:

    &quot;typescript&quot;: &quot;^2.0.3&quot;
    &quot;webpack&quot;: &quot;2.1.0-beta.25&quot;
    &quot;webpack-dev-server&quot;: &quot;^2.1.0-beta.9&quot;
    &quot;react&quot;: &quot;^15.4.0-rc.4&quot;
    &quot;react-toolbox&quot;: &quot;^1.2.3&quot;
    &quot;node-sass&quot;: &quot;^3.10.1&quot;
    &quot;style-loader&quot;: &quot;^0.13.1&quot;
    &quot;css-loader&quot;: &quot;^0.25.0&quot;
    &quot;sass-loader&quot;: &quot;^4.0.2&quot;
    &quot;sass-lint&quot;: &quot;^1.9.1&quot;
    &quot;sasslint-webpack-plugin&quot;: &quot;^1.0.4&quot;

Here is my `webpack.config.js`

    var path = require(&#39;path&#39;);
    var webpack = require(&#39;webpack&#39;);
    var sassLintPlugin = require(&#39;sasslint-webpack-plugin&#39;);
    
    module.exports = {
      entry: [
        &#39;webpack-dev-server/client?http://localhost:8080&#39;,
        &#39;webpack/hot/dev-server&#39;,
        &#39;./src/index.tsx&#39;,
      ],
      output: {
        path: path.resolve(__dirname, &#39;dist&#39;),
        publicPath: &#39;http://localhost:8080/&#39;,
        filename: &#39;dist/bundle.js&#39;,
      },
      devtool: &#39;source-map&#39;,
      resolve: {
        extensions: [&#39;.webpack.js&#39;, &#39;.web.js&#39;, &#39;.ts&#39;, &#39;.tsx&#39;, &#39;.js&#39;],
      },
      module: {
        rules: [{
          test: /\.js$/,
          loader: &#39;source-map-loader&#39;,
          exclude: /node_modules/,
          enforce: &#39;pre&#39;,
        }, {
          test: /\.tsx?$/,
          loader: &#39;tslint-loader&#39;,
          exclude: /node_modules/,
          enforce: &#39;pre&#39;,
        }, {
          test: /\.tsx?$/,
          loaders: [
            &#39;react-hot-loader/webpack&#39;,
            &#39;awesome-typescript-loader&#39;,
          ],
          exclude: /node_modules/,
        }, {
          test: /\.scss$/,
          loaders: [&#39;style&#39;, &#39;css&#39;, &#39;sass&#39;]
        }, {
          test: /\.css$/,
          loaders: [&#39;style&#39;, &#39;css&#39;]
        }],
      },
      externals: {
        &#39;react&#39;: &#39;React&#39;,
        &#39;react-dom&#39;: &#39;ReactDOM&#39;
      },
      plugins: [
        new sassLintPlugin({
          glob: &#39;src/**/*.s?(a|c)ss&#39;,
          ignoreFiles: [&#39;src/normalize.scss&#39;],
          failOnWarning: false, // Do it.
        }),
        new webpack.HotModuleReplacementPlugin(),
      ],
      devServer: {
        contentBase: &#39;./&#39;
      },
    };

and my `App.tsx` where I&#39;m trying to import:

    import * as React from &#39;react&#39;;
    
    import { AppBar } from &#39;react-toolbox&#39;;
    import appBarTheme from &#39;react-toolbox/components/app_bar/theme.scss&#39;
    // local ./theme.scss stylesheets aren&#39;t found either 
    
    interface IAppStateProps {
      // No props yet
    }
    
    interface IAppDispatchProps {
      // No state yet
    }
    
    class App extends React.Component&lt;IAppStateProps &amp; IAppDispatchProps, any&gt; {
    
      constructor(props: IAppStateProps &amp; IAppDispatchProps) {
        super(props);
      }
    
      public render() {
        return (
    
            &lt;div className=&#39;wrapper&#39;&gt;
              &lt;AppBar title=&#39;My App Bar&#39; theme={appBarTheme}&gt;
              &lt;/AppBar&gt;
            &lt;/div&gt;
    
        );
      }
    }
    
    export default App;

What else is required to enable typesafe stylesheet module importing?

Can&#39;t import CSS/SCSS modules. TypeScript says &quot;Cannot Find Module&quot;

I was reading the es6 import statement [reference on MDN](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/import). The syntax:

    import &quot;my-module&quot;;

will import an entire module for side effects only, without importing any bindings. I am not sure what **side effects** mean. I have been using with **angular** by saying `import &quot;angular&quot;`. Angular binds to window but does not return a object. So I am not sure if this would be called as a side effect exactly.

 

es6 import for side effects meaning

If you know how to toggle `soft wrap` aka. word wrap while editing code in Pycharm, please share.

My [google search][1] and [SO search][2] give me no helpful result(s).

Trying to look in Pycharm setting/preference not helps either.

p.s.

I&#39;m using **PyCharm Community Edition 2016.2**


  [1]: https://www.google.com.vn/#newwindow=1&amp;q=pycharm%20soft%20wrap%20for%20code%20editor&amp;rct=j
  [2]: https://stackoverflow.com/questions/34340899/is-use-soft-wraps-option-not-available-in-preferences-in-pycharm-again-ver-5

Pycharm to toggle soft wrap in code editor

I am using PyCharm 2016.2.1 . When I try to view a Pandas dataframe through the newly added feature &#39;View as DataFrame&#39; in the debugger, this works as expected for a small (e.g. 4x4) DataFrame. 

However when I try to view a DataFrame (generated by custom script) of ~10,000 rows x ~50 columns, I get the message: &quot;Nothing to show&quot;. 

When I run the same script (that generates the DataFrame) in Spyder, I am able to view it, so I am pretty sure it&#39;s not an error in my script. 

Does anyone know if there is a maximum size to the DataFrames that can be viewed in PyCharm, and if there is a way to change this? 

EDIT:
======

It seems that the maximum size allowed is 1000 x 15 , as in some cases it gets truncated to this size (when the number of rows is too large, but when there are too many columns pycharm just says &#39;nothing to show&#39;).

Still, I would like to know if there is a way to increase the maximum allowed rows and columns viewable through the DataFrame viewer.

Dataframe not showing in Pycharm

I understand how to increase the font size within an editor tab, but I&#39;d like to increase the font size of the main navigation menu and most importantly, the tab titles.  These do not change when I zoom in or out of an editor tab (using Cmd + mouse wheel on OSX). I do not see anything in the preferences menus.



How to increase menu and tab font size in IntelliJ JetBrains PyCharm, PhpStorm, RubyMine

I am debugging a Python (`3.5`) program with PyCharm (`PyCharm Community Edition 2016.2.2 ; Build #PC-162.1812.1, built on August 16, 2016 ; JRE: 1.8.0_76-release-b216 x86 ; JVM: OpenJDK Server VM by JetBrains s.r.o`) on Windows 10.

**The problem: when stopped at some breakpoints, the Debugger window is stuck at &quot;Collecting data&quot;, which eventually timeout.** (with *Unable to display frame variables*)

The data to be displayed is neither special, nor particularly large. It is somehow available to PyCharm since a conditional break point on some values of the said data works fine (the program breaks) -- it looks like the process to gather it for display only (as opposed to operational purposes) fails.

When I step into a function around the place I have my breakpoint, its data is displayed correctly. When I go up the stack (to the calling function, the one I stepped down from and where I wanted initially to have the breakpoint) - I am stuck with the &quot;Collecting data&quot; timeout again.

There have been numerous issues raised with the same point since at least 2005. Some were fixed, some not. The fixes were usually updates to the latest version (which I have).

**Is there a general direction I can go to in order to fix or work around this family of problems?**

---

EDIT: a year later the problem is still there and there is still no reaction from the devs/support after the bug was raised.

---

**EDIT April 2018: It looks like the problem is solved in the 2018.1 version**, the following code which was hanging when setting a breakpoint on the `print` line now works (I can see the variables):

    import threading
    
    def worker():
        a = 3
        print(&#39;hello&#39;)
    
    threading.Thread(target=worker).start()

Debugger times out at &quot;Collecting data...&quot;

PyCharm provides some helpful warnings on code style, conventions and logical gotchas. It also provides a notification if I try to commit code with warnings (or errors).

Sometimes I consciously ignore these warnings for particular lines of code (for various reasons, typically to account for implementation details of third-party libraries). I want to suppress the warning, but just for that line (if the warning crops up on a different line where I&#39;m not being deliberate, I want to know about it!)

How can I do that in PyCharm? (Following a universal Python convention strongly preferable.)

Content Type	Original Author	Original Content on Stackoverflow
Question	allenlin1992	View Question on Stackoverflow
Solution 1 - Python	Bobby	View Answer on Stackoverflow
Solution 2 - Python	Brent Washburne	View Answer on Stackoverflow
Solution 3 - Python	mircealungu	View Answer on Stackoverflow
Solution 4 - Python	petibonum	View Answer on Stackoverflow
Solution 5 - Python	nidkil	View Answer on Stackoverflow

Pycharm import RuntimeWarning after updating to 2016.2

Python Problem Overview

Python Solutions

Solution 1 - Python

Solution 2 - Python

Solution 3 - Python

Solution 4 - Python

Solution 5 - Python

beautifulsoup, html5lib: module object has no attribute _base

ASP.NET Core - The name 'JsonRequestBehavior' does not exist in the current context

Attributions