Authentication method ‘caching_sha2_password’ not supported by any of the available plugins Error while connecting Toad with MySQL

I followed the following 2 stpes:

1. Change the content of the ‘my.ini’ file at following location: C:\ProgramData\MySQL\MySQL Server 8.0 default_authentication_plugin=mysql_native_password

2. ALTER USER ‘user’@’localhost’ IDENTIFIED WITH
-> mysql_native_password BY ‘rootpassword’;

Some nice python Box-plot tutorials

1. http://blog.bharatbhole.com/creating-boxplots-with-matplotlib/

Start or stop service in windows 8

Its very easy to start or stop service in windows 8.

1. go to “run”
2. Type “services.msc”
3. Right click on MySql  (or any other servics) and click start

import error VarianceThreshold python

I am facing problem in importing libraries used for feature selection.  I used following steps.

1.Remove sklearn  (version 0.14.1 32 bit) from control panel.

2. Install sklearn version 0.17b1

3 deleted file:

python27\Lib\site-packages\sklearn\utils\sparsefuncs.pyd

( you will get error "  ImportError: cannot import name inplace_column_scale"  if you will not delete this file).
4. solved!

Numpy hstack – “ValueError: all the input arrays must have same number of dimensions” – but they do

Combing Numerical and Textual Features in Python. Some while applying in following way we get error:

total_data = np.hstack([total_text_features.toarray(), total_numerical_features])

Error:

Traceback (most recent call last):
File “F:\Research\git-repositories\logging2\logging2\src\test.py”, line 94, in <module>
total_data = np.hstack([total_text_features.toarray(), total_numerical_features])
File “C:\Python27\lib\site-packages\numpy\core\shape_base.py”, line 277, in hstack
return _nx.concatenate(arrs, 1)
ValueError: all the input arrays must have same number of dimensions

======================================================================

Correct above error in following way:

total_data = np.column_stack([total_text_features.toarray(), total_numerical_features])

Above error occurs because of sparse data.

Download stopwords from nltk library

Download stopwords  from nltk library

>>import nltk
>>> nltk.download()

in NLTK Donwloader select following:

1. go to corpora

2. within corpora select stopwords

3. click download

Otherwise you may get following error:

except LookupError: raise e
LookupError:
**********************************************************************
Resource u’corpora/stopwords’ not found. Please use the NLTK
Downloader to obtain the resource: >>> nltk.download()
Searched in:
– ‘C:\\Users\\myHp/nltk_data’
– ‘C:\\nltk_data’
– ‘D:\\nltk_data’
– ‘E:\\nltk_data’
– ‘C:\\Python27\\nltk_data’
– ‘C:\\Python27\\lib\\nltk_data’
– ‘C:\\Users\\myHp\\AppData\\Roaming\\nltk_data’
**********************************************************************

Goddess Saraswati: Goddess of knowledge! Learning!

Goddess Saraswati is the goddess of learning and knowledge. She looks very beautiful and elegant. I was always curious to know more about her as I think there is a strong connection between her appearance and ways of living life. Here I will share my thoughts on her appearance based on my knowledge and research.

1. White clothes: Among all the colours white is the only colour that return every other colour. This gives that we should always return back the society. We should always be thankful for what we have. Even if we can not return in monitory terms we can return in terms of blessing! prayer! emotional support.

2. Swan: It is the only bird which if given milk mix with water, can separate milk from water. This gives an indication that we should have wisdom to separate good from bad. Whenever we get any offering we should be only accept good things from it.

3. Veena: searching..

4. Books (Veda):searching..

5. White Lotus:searching..

6. White Pearl:searching..

How to check version of installed Python Modules

Run following command on your Python prompt:

>>
print matplotlib.__version__

matplotlib is the name of the package. Replace it with desired package.

How to easy_install in python

Use above image for easy installing  modules in python.

Github Pull Request

While Pulling project from github, it automatically creates a repository in github repository view.

1 ) Now to run the file we need to import the project. For this we have to copy the peorject url from github and use eclipse import menu. While select the location of the project we have to select the location of github -repository not the new workspace location.

2) To pull the changes in the project, apply pull request on repository present in github  view folder. It will bring changes automatically in the project present in project explorer location.

Omg: Shorter way:

1. Open eclipse

2. Go to location where git repositories are shown:

3. do right click and paste the on the same place

4. Here write your githhub uri: https://github.com/user- name/project.git

(This is give on github copy it from there)

5. Enter user name and password, and press next.

6. Select your local repository

E:\User\logging (project name)