MySQL Installation, Queries, ODBC Setup and Views in Alteryx

Skin Allergy (Jun-2017)

Tags: Medical Prescription,Journal

Patience (Joke and Lesson)

I was 25. Years, not Kilograms. Looking for bride.
Now my family puts up a lot of conditions of the selection of the girl. As follows:

At 25: Jain girl with Jain diet

I turned 26 with no match found. Now my family reduces constraints.

26: Find a Jain girl.

I turned 27 with no match found. My family reduces the constraints further.

27: Find a Jain or Gupta girl.

I turned 28 with no match found. My family reduces the constraints further.

28: Just a vegetarian girl would be fine.

I turned 29 with no luck yet in finding a girl. My family reduces constraints further.

29: My family says unemployed girl would also do fine.

My friend Sandeep tells me that wait for 5 more years and they would agree to a girl who does smack and coke.

Patience is the key ingredient to successful execution of any plan.

Journal,Joke,

Packaged Food (2021-Sep-26)

Index of Journals

Cold (Sep-2017, Dr Ajay Dewan)

Steps toward: virtualenv, jupyter notebook, jupyterlab, ipykernel, SpaCy model (en_core_web)

Steps toward: virtualenv, jupyter notebook, jupyterlab, ipykernel, SpaCy model (en_core_web)

$ pip install virtualenv
$ virtualenv ve1 --python=python3.8

INSTALL JUPYTER NOTEBOOK AND JUPYTERLAB FROM TERMINAL ON UBUNTU:

$ sudo apt install jupyter-core
$ pip install jupyter
$ pip install jupyterlab

(ve1) $ python3 -m notebook

[I 11:56:51.871 NotebookApp] Writing notebook server cookie secret to /home/ashi/.local/share/jupyter/runtime/notebook_cookie_secret
[I 11:56:52.175 NotebookApp] Serving notebooks from local directory: /home/ashi/Desktop/ws
[I 11:56:52.175 NotebookApp] Jupyter Notebook 6.4.4 is running at:
[I 11:56:52.175 NotebookApp] http://localhost:8888/?token=1b335a35516298724494a1ff32e309334d3a819a633719fc
[I 11:56:52.175 NotebookApp]  or http://127.0.0.1:8888/?token=1b335a35516298724494a1ff32e309334d3a819a633719fc
[I 11:56:52.175 NotebookApp] Use Control-C to stop this server and shut down all kernels (twice to skip confirmation).
[C 11:56:52.221 NotebookApp] 
    
    To access the notebook, open this file in a browser:
        file:///home/ashi/.local/share/jupyter/runtime/nbserver-13598-open.html
    Or copy and paste one of these URLs:
        http://localhost:8888/?token=1b335a35516298724494a1ff32e309334d3a819a633719fc
        or http://127.0.0.1:8888/?token=1b335a35516298724494a1ff32e309334d3a819a633719fc
/usr/lib/python3.9/json/encoder.py:257: UserWarning: date_default is deprecated since jupyter_client 7.0.0. Use jupyter_client.jsonutil.json_default.
    return _iterencode(o, 0)
[W 11:56:59.140 NotebookApp] 404 GET /lab/tree/Desktop (127.0.0.1) 15.820000ms referer=None

###   ###   ###   ###   ###   

(ve1) $ python3 -m jupyterlab

[I 2021-09-22 11:58:03.326 ServerApp] jupyterlab | extension was successfully linked.
[I 2021-09-22 11:58:03.357 LabApp] JupyterLab extension loaded from /home/ashi/.local/lib/python3.9/site-packages/jupyterlab
[I 2021-09-22 11:58:03.357 LabApp] JupyterLab application directory is /home/ashi/.local/share/jupyter/lab
[I 2021-09-22 11:58:03.360 ServerApp] jupyterlab | extension was successfully loaded.
[I 2021-09-22 11:58:03.361 ServerApp] The port 8888 is already in use, trying another port.
[I 2021-09-22 11:58:03.361 ServerApp] Serving notebooks from local directory: /home/ashi/Desktop/ws/ve1/bin
[I 2021-09-22 11:58:03.361 ServerApp] Jupyter Server 1.11.0 is running at:
[I 2021-09-22 11:58:03.362 ServerApp] http://localhost:8889/lab?token=9bcab4ac0599e2c3c086f1ace8376d6d8221fd074bdaf066
[I 2021-09-22 11:58:03.362 ServerApp]  or http://127.0.0.1:8889/lab?token=9bcab4ac0599e2c3c086f1ace8376d6d8221fd074bdaf066
[I 2021-09-22 11:58:03.362 ServerApp] Use Control-C to stop this server and shut down all kernels (twice to skip confirmation).
[W 2021-09-22 11:58:03.371 ServerApp] No web browser found: could not locate runnable browser.
[C 2021-09-22 11:58:03.371 ServerApp] 
    
    To access the server, open this file in a browser:
        file:///home/ashi/.local/share/jupyter/runtime/jpserver-14003-open.html
    Or copy and paste one of these URLs:
        http://localhost:8889/lab?token=9bcab4ac0599e2c3c086f1ace8376d6d8221fd074bdaf066
        or http://127.0.0.1:8889/lab?token=9bcab4ac0599e2c3c086f1ace8376d6d8221fd074bdaf066
[W 2021-09-22 11:58:44.209 LabApp] Could not determine jupyterlab build status without nodejs
[W 2021-09-22 11:58:47.988 ServerApp] 404 GET /api/contents/Desktop?1632292127985 (127.0.0.1): No such file or directory: Desktop
[W 2021-09-22 11:58:47.988 ServerApp] No such file or directory: Desktop
[W 2021-09-22 11:58:47.988 ServerApp] 404 GET /api/contents/Desktop?1632292127985 (127.0.0.1) 1.34ms referer=http://127.0.0.1:8889/lab

###   ###   ###   ###   ###   

$ pip install ipykernel

(ve1) ashi@ashi-VirtualBox:/home/ashi/Desktop/ws$ python3 -m ipykernel install --name ve1
[Errno 13] Permission denied: '/usr/local/share/jupyter'
(ve1) ashi@ashi-VirtualBox:/home/ashi/Desktop/ws$ python3 -m ipykernel install --user --name ve1
Installed kernelspec ve1 in /home/ashi/.local/share/jupyter/kernels/ve1


###   ###   ###   ###   ###   

(ve1) ashi@ashi-VirtualBox:/home/ashi/Desktop/ws$ python3 -m spacy download en_core_web_sm
Collecting en-core-web-sm==3.1.0
    WARNING: Retrying (Retry(total=4.... connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)'))': /explosion/spacy-models/releases/download/en_core_web_sm-3.1.0/en_core_web_sm-3.1.0-py3-none-any.whl
ERROR: Could not install packages due to an EnvironmentError: HTTPSConnectionPool(host='github.com', port=443): Max retries exceeded with url: /explosion/spacy-models/releases/download/en_core_web_sm-3.1.0/en_core_web_sm-3.1.0-py3-none-any.whl (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)')))

We download the wheel file from the GitHub link and install as follows
$ pip install en_core_web_sm-3.1.0-py3-none-any.whl

###   ###   ###   ###   ###   

Tags: Python,Technology,Anaconda,

Anaconda Setup on Ubuntu for the First Time

First time Anaconda setup is done using the following commands:

1. 
~/Downloads$ ls -l
total 712608
-rwxrwxrwx 1 ashi ashi 570853747 Sep 21 12:43 Anaconda3-2021.05-Linux-x86_64.sh

2. 
$ chmod 777 Anaconda3-2021.05-Linux-x86_64.sh

3. 
~/Downloads$ ./Anaconda3-2021.05-Linux-x86_64.sh 

4. 
$ cd ~/anaconda3/bin

5. 
~/anaconda3/bin$ ./conda init bash 

no change     /home/ashi/anaconda3/condabin/conda
no change     /home/ashi/anaconda3/bin/conda
no change     /home/ashi/anaconda3/bin/conda-env
no change     /home/ashi/anaconda3/bin/activate
no change     /home/ashi/anaconda3/bin/deactivate
no change     /home/ashi/anaconda3/etc/profile.d/conda.sh
no change     /home/ashi/anaconda3/etc/fish/conf.d/conda.fish
no change     /home/ashi/anaconda3/shell/condabin/Conda.psm1
no change     /home/ashi/anaconda3/shell/condabin/conda-hook.ps1
no change     /home/ashi/anaconda3/lib/python3.8/site-packages/xontrib/conda.xsh
no change     /home/ashi/anaconda3/etc/profile.d/conda.csh
modified      /home/ashi/.bashrc

==> For changes to take effect, close and re-open your current shell. <== 

CHANGES AUTOMATICALLY PUSHED IN THE FILE: /home/ashi/.bashrc
# >>> conda initialize >>>
# !! Contents within this block are managed by 'conda init' !!
__conda_setup="$('/home/ashi/anaconda3/bin/conda' 'shell.bash' 'hook' 2> /dev/null)"
if [ $? -eq 0 ]; then
    eval "$__conda_setup"
else
    if [ -f "/home/ashi/anaconda3/etc/profile.d/conda.sh" ]; then
        . "/home/ashi/anaconda3/etc/profile.d/conda.sh"
    else
        export PATH="/home/ashi/anaconda3/bin:$PATH"
    fi
fi
unset __conda_setup
# <<< conda initialize <<<


~/anaconda3/bin$ ./conda activate base

CommandNotFoundError: Your shell has not been properly configured to use 'conda activate'.
To initialize your shell, run

    $ conda init <SHELL_NAME>

Currently supported shells are:
    - bash
    - fish
    - tcsh
    - xonsh
    - zsh
    - powershell

See 'conda init --help' for more information and options.

IMPORTANT: You may need to close and restart your shell after running 'conda init'. 

6.
~/anaconda3/bin$ bash

To run a command as administrator (user "root"), use "sudo <command>".
See "man sudo_root" for details.

(base) ~/anaconda3/bin$
Tags: Technology,Anaconda,Python,

2011-Feb-16 (Night fall)

Index of Journals

February 16, 2011

I was not supposed to be awakening early this morning had I not been having night-fall in the bed. Well, it was okay since I had things to study. I was not about to do math-like subject with brain still partially asleep. I read the Software Engineering text book, a theoretical subject. Now I was feeling lucky for not having attending to classes of this bullshit. 

I took to reading “Accidental Billionaires” by Ben Mezrich on the founding of the ‘Facebook’. The story still inspires me, again, and over again. 

In the morning the security guard, Amar-singh entangled with some man who had problem with the watchman. Watchman claimed that the man abused him before starting to talk and the discussion was given a new useless shape far away from the reason why it was born. An abuse could do this much, surprising. 

Gurarchi still texts me, probably because she got Anurag to explain her about my situation. Anurag had gone far from me last year but because we have a mutual contact, and more because it is a girl, Anurag is again a close friend. 

I didn’t remove a wrong tag from my Facebook profile for school-friends. I anyway don’t use it so it didn’t seem important to me. Now, there’s only one photo of me with other boys of XII-D and then there’s a photo of senior ‘Ashish Jain’, whom I better know as Anu’s ex-boyfriend.

God Bless ‘Me’
Ashish 

2011-Feb-15 (Mass Bunk culture at ADGITM)

Index of Journals

February 15, 2011

Dhanraj, Dinesh, and I were climbing the stairs when Dhanraj said he hadn’t seen Neeru madam’s face since many days. And Neeru ma’am was standing right on the next floor to see us coming, she heard him clearly. I was about to comment but then I cautiously stopped. It was 8am class. I was like about to fall while sitting on the first bench and Neeru ma’am had to comment that if I was to fall like this in first period then god only knows what would happen in the later ones. 

Aditya is ignoring me. Well it wasn’t my fault when he came late for the ADA class and sir said, “Nice to meet you, Tata-bye-bye,” from the closed door. I was on the first bench but I couldn’t have helped in any way. 

In Computer Graphics lab, that jerk teacher made my day awful. Anshul-whatever is his name. Yes, he had once come to take OOPS substitution last semester and then started teaching us Yoga and breathing exercises. I have got to dislike him. He speaks as if he’s just learning to speak. Tanvi Gautam is a slut, I will say this on every day I will have an encounter with her. One good thing about Anshul sir is that though I’m never writing in his period but he never punished me for that. 

Faizan never brings his own lunch and pecks on the lunch boxes of those who get it. It is sick to share food with people like him, Kirti Mohan was another, idiots.

When students called out for mass bunk in the last period off Software Engineering, many were not in the mood to do that. Some were sitting in the class, and the mass-bunkers had already come out with bags packed. When the teacher came to the class, they came in with her and made the teacher leave with attendance. Swarnlata ma’am is such an idiot, young, beautiful, and an idiot. I was almost on my nerves when I saw the back benchers made the teacher leave. I mean, what are the rest of the all who were sitting to attend the class, donkeys? And, it made me so irritated because though being the class coordinator I was able to do nothing, I had no say. I couldn’t have said anything. Only this thing was pissing me off for another hour after that. But then I settled with the thought that self-studying is way better than attending to an idiot on lecturer’s post. And that applies to almost every teacher in this college. I hate NIEC.

God Bless ‘Me’
Ashish 

2011-Feb-14 (Clean-up of Facebook Profile)

Index of Journals

February 14, 2011

Happy Valentines Day
I woke up on time around 0630. I went to college but missed the 8am class, Swarnlata madam‘s class again.
I was marked absent for not bringing the file by this pathetic woman, Neeru ma’am, in the DCS (Digital Circuits and Systems) lab. The period after break, CS communication systems class, was mass-bunked and class attended DCS, Neeru madam’s period. 
I sat in library till 1800 and I had this nice bus ride to get back home.

I deleted my song ‘Flashback’ from my school-profile on Facebook before accepting Jagdish (JD sir, my high school class teacher) sir’s friend request. I had written that song to just speak out my unsaid thoughts and feelings about my school life-and-Sonal to my school friends and Sonal. That song posted in May 2010 after declaration of JEE result just got deleted. I very critically acclaimed by many who were tagged in that note and who read that note. It was my first public release. I removed “married to my ego” thing from “about me” column, but didn’t change my “married” relationship status. And my birthday date is 18th Dec again. 

Babaji handed me R500 note in the morning for studying. Now, my money-packet is pregnant again, it breached R4700 mark after 1 year and 3 months. 

God Bless ‘Me’
Ashish