Update: I have picked up Julia again in 2020 and I am enjoying it.
As an Amazon Associate I earn from qualifying purchases.
Julia language is not ready (2018)
Update: I have picked up Julia again in 2020 and I am enjoying it.
I have tried countless code examples and most of them fail.
The most important to me "using PyCall" was the final signal for me that Julia and I need a little time apart. Maybe when some percentage of packages make it from 0.1 and 0.3 to something like 0.9 and 1.0 then Julia will be more usable.
import Pkg;
Pkg.add("PyCall")
Updating registry at `~/.julia/registries/General` Updating git-repo `https://github.com/JuliaRegistries/General.git` [1mFetching: [========================================>] 100.0 %.0 %
Resolving package versions...
Updating `~/.julia/environments/v1.0/Project.toml` [5c1ef01f]
- Cookbook v0.3.0 [5befdd30] - Hilbert v0.1.0 [5c077215]
- LatticeSites v0.2.0 Updating `~/.julia/environments/v1.0/Manifest.toml` [5c1ef01f]
- Cookbook v0.3.0 [5befdd30]
- Hilbert v0.1.0 [5c077215]
- LatticeSites v0.2.0
Pkg.update()
Updating registry at `~/.julia/registries/General`
Updating git-repo `https://github.com/JuliaRegistries/General.git`
Resolving package versions...
Installed KernelDensity ── v0.5.1
Installed Interpolations ─ v0.9.2
Updating `~/.julia/environments/v1.0/Project.toml` [5cadff95]
- JuliennedArrays v0.1.0 [5ab0869b] ↑ KernelDensity v0.5.0 ⇒ v0.5.1 [5c958174]
- SuperEnum v0.1.3 Updating `~/.julia/environments/v1.0/Manifest.toml` [a98d9a8b] ↓ Interpolations v0.10.5 ⇒ v0.9.2 [5cadff95]
- JuliennedArrays v0.1.0 [5ab0869b] ↑
KernelDensity v0.5.0 ⇒ v0.5.1 [5c958174]
- SuperEnum v0.1.3
using PyCall
SYSTEM: show(lasterr) caused an error Stacktrace: [1] _include_from_serialized(::String, ::Array{Any,1}) at ./loading.jl:630 [2] macro expansion at ./logging.jl:312 [inlined] [3] _require_search_from_serialized(::Base.PkgId, ::String) at ./loading.jl:701 [4] _require(::Base.PkgId) at ./loading.jl:934 [5] require(::Base.PkgId) at ./loading.jl:855 [6] macro expansion at ./logging.jl:311 [inlined] [7] require(::Module, ::Symbol) at ./loading.jl:837 [8] top-level scope at In[1]:1The error above prevents the execution of the below:
KERNEL EXCEPTION
SYSTEM: show(lasterr) caused an errorStacktrace:
[1] #invokelatest#1 at ./essentials.jl:697 [inlined]
[2] invokelatest at ./essentials.jl:696 [inlined]
[3] eventloop(::ZMQ.Socket) at /Users/uki/.julia/packages/IJulia/0cLgR/src/eventloop.jl:8
[4] (::getfield(IJulia, Symbol("##12#15")))() at ./task.jl:259
@pyimport math
#math.sin(math.pi / 4) - sin(pi / 4) # returns 0.0
@pyimport time
@pyimport numpy.random as nr nr.rand(3,4)
Jupyter Error 49
$ jupyter notebook
Traceback (most recent call last):
File "/anaconda3/bin/jupyter-notebook", line 11, in
sys.exit(main())
File "/anaconda3/lib/python3.7/site-packages/jupyter_core/application.py", line 266, in launch_instance
return super(JupyterApp, cls).launch_instance(argv=argv, **kwargs)
File "/anaconda3/lib/python3.7/site-packages/traitlets/config/application.py", line 657, in launch_instance
app.initialize(argv)
File "", line 2, in initialize
File "/anaconda3/lib/python3.7/site-packages/traitlets/config/application.py", line 87, in catch_config_error
return method(app, *args, **kwargs)
File "/anaconda3/lib/python3.7/site-packages/notebook/notebookapp.py", line 1602, in initialize
self.init_webapp()
File "/anaconda3/lib/python3.7/site-packages/notebook/notebookapp.py", line 1381, in init_webapp
self.http_server.listen(port, self.ip)
File "/anaconda3/lib/python3.7/site-packages/tornado/tcpserver.py", line 143, in listen
sockets = bind_sockets(port, address=address)
File "/anaconda3/lib/python3.7/site-packages/tornado/netutil.py", line 168, in bind_sockets
sock.bind(sockaddr)
OSError: [Errno 49] Can't assign requested address
Short Answer
$ jupyter notebook --ip=127.0.0.1
PORT 8888
You can also explore what you are already running on PORT 8888$ lsof | grep 8888Skype 407 uki txt REG 1,5
$ lsof -nP | grep 8888
Jupyter Error 49
$ jupyter notebook
Traceback (most recent call last):
File "/anaconda3/bin/jupyter-notebook", line 11, in
sys.exit(main())
File "/anaconda3/lib/python3.7/site-packages/jupyter_core/application.py", line 266, in launch_instance
return super(JupyterApp, cls).launch_instance(argv=argv, **kwargs)
File "/anaconda3/lib/python3.7/site-packages/traitlets/config/application.py", line 657, in launch_instance
app.initialize(argv)
File "", line 2, in initialize
File "/anaconda3/lib/python3.7/site-packages/traitlets/config/application.py", line 87, in catch_config_error
return method(app, *args, **kwargs)
File "/anaconda3/lib/python3.7/site-packages/notebook/notebookapp.py", line 1602, in initialize
self.init_webapp()
File "/anaconda3/lib/python3.7/site-packages/notebook/notebookapp.py", line 1381, in init_webapp
self.http_server.listen(port, self.ip)
File "/anaconda3/lib/python3.7/site-packages/tornado/tcpserver.py", line 143, in listen
sockets = bind_sockets(port, address=address)
File "/anaconda3/lib/python3.7/site-packages/tornado/netutil.py", line 168, in bind_sockets
sock.bind(sockaddr)
OSError: [Errno 49] Can't assign requested address
Short Answer
$ jupyter notebook --ip=127.0.0.1
PORT 8888
You can also explore what you are already running on PORT 8888$ lsof | grep 8888Skype 407 uki txt REG 1,5
$ lsof -nP | grep 8888
Julia
Download Julia
https://julialang.org/downloads/
For me, MacOS Package (.dmg)
_
_ _ _(_)_ | Documentation: https://docs.julialang.org (_) | (_) (_) | _ _ _| |_ __ _ | Type "?" for help, "]?" for Pkg help. | | | | | | |/ _` | | | | |_| | | | (_| | | Version 1.0.1 (2018-09-29) _/ |\__'_|_|_|\__'_| | Official https://julialang.org/ release|__/ |
julia> println("Hello World,", "Julia!")Hello World,Julia!
Clone Julia:
git clone https://github.com/JuliaLang/julia.git
Visit JuliaBox.com (iJulia Jupyter notebooks):
JuliaBox.com
Install Juno (Atom IDE)
http://docs.junolab.org/latest/man/installation.html
iJulia in Jupyter Notebook
julia> using Pkg
julia> Pkg.add("IJulia")
Jupyter NBInclude.jl
https://github.com/stevengj/NBInclude.jl
$ git clone https://github.com/stevengj/NBInclude.jl.git julia_NBInclude
Julia
Download Julia
https://julialang.org/downloads/
For me, MacOS Package (.dmg)
_
_ _ _(_)_ | Documentation: https://docs.julialang.org (_) | (_) (_) | _ _ _| |_ __ _ | Type "?" for help, "]?" for Pkg help. | | | | | | |/ _` | | | | |_| | | | (_| | | Version 1.0.1 (2018-09-29) _/ |\__'_|_|_|\__'_| | Official https://julialang.org/ release|__/ |
julia> println("Hello World,", "Julia!")Hello World,Julia!
Clone Julia:
git clone https://github.com/JuliaLang/julia.git
Visit JuliaBox.com (iJulia Jupyter notebooks):
JuliaBox.com
Install Juno (Atom IDE)
http://docs.junolab.org/latest/man/installation.html
iJulia in Jupyter Notebook
julia> using Pkg
julia> Pkg.add("IJulia")
Jupyter NBInclude.jl
https://github.com/stevengj/NBInclude.jl
$ git clone https://github.com/stevengj/NBInclude.jl.git julia_NBInclude
Windows 10 UBuntu bash
My company uses mostly Windows and Ubuntu servers, I requested a MacBook, obviously.
However, there are certain internally-written programs that will run on the Windows only, so I run Parallels hypervisor with Windows 10 and Ubuntu.
On Windows 10, I have a hard time with the Command Prompt, last time I used DOS was in c. 1999, so I opted to try installing Bash.
64 bytes from yi-in-f102.1e100.net (74.125.138.102): icmp_seq=1 ttl=128 time=30.4 ms
Command 'python' not found, but can be installed with:
sudo apt install python3
sudo apt install python
sudo apt install python-minimal
You also have python3 installed, you can run 'python3' instead.
Command 'java' not found, but can be installed with:
OpenJDK Runtime Environment (build 10.0.1+10-Ubuntu-3ubuntu1)
OpenJDK 64-Bit Server VM (build 10.0.1+10-Ubuntu-3ubuntu1, mixed mode)
However, there are certain internally-written programs that will run on the Windows only, so I run Parallels hypervisor with Windows 10 and Ubuntu.
On Windows 10, I have a hard time with the Command Prompt, last time I used DOS was in c. 1999, so I opted to try installing Bash.
$ ping Google.comPING Google.com (74.125.138.102) 56(84) bytes of data.
64 bytes from yi-in-f102.1e100.net (74.125.138.102): icmp_seq=1 ttl=128 time=30.4 ms
$ ssh dummy@74.125.138.102ssh: connect to host 74.125.138.102 port 22: Connection refused
Checking for Python
$ python --version
Command 'python' not found, but can be installed with:
sudo apt install python3
sudo apt install python
sudo apt install python-minimal
You also have python3 installed, you can run 'python3' instead.
$ python3 --version
Python 3.6.5
$ python3
Python 3.6.5 (default, Apr 1 2018, 05:46:30)
[GCC 7.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> print("Hello World")
Hello World
>>> exit()
$
Attempting to get Anaconda
wget https://3230d63b5fc54e62148e-c95ac804525aac4b6dba79b00b39d1d3.ssl.cf1.rackcdn.com/Anaconda-2.3.0-Linux-x86_64.sh-bash: .: Anaconda-2.3.0-Linux-x86_64.sh: cannot execute binary file
$ chmod +x Anaconda-2.3.0-Linux-x86_64.sh
$ . Anaconda-2.3.0-Linux-x86_64.sh
$ java
Command 'java' not found, but can be installed with:
$ sudo apt install default-jre
$ sudo apt install openjdk-11-jre-headless
$ sudo apt install openjdk-8-jre-headless
$ sudo apt install openjdk-11-jre-headless
$ java --versionopenjdk 10.0.1 2018-04-17
OpenJDK Runtime Environment (build 10.0.1+10-Ubuntu-3ubuntu1)
OpenJDK 64-Bit Server VM (build 10.0.1+10-Ubuntu-3ubuntu1, mixed mode)
Windows 10 UBuntu bash
My company uses mostly Windows and Ubuntu servers, I requested a MacBook, obviously.
However, there are certain internally-written programs that will run on the Windows only, so I run Parallels hypervisor with Windows 10 and Ubuntu.
On Windows 10, I have a hard time with the Command Prompt, last time I used DOS was in c. 1999, so I opted to try installing Bash.
64 bytes from yi-in-f102.1e100.net (74.125.138.102): icmp_seq=1 ttl=128 time=30.4 ms
Command 'python' not found, but can be installed with:
sudo apt install python3
sudo apt install python
sudo apt install python-minimal
You also have python3 installed, you can run 'python3' instead.
Command 'java' not found, but can be installed with:
OpenJDK Runtime Environment (build 10.0.1+10-Ubuntu-3ubuntu1)
OpenJDK 64-Bit Server VM (build 10.0.1+10-Ubuntu-3ubuntu1, mixed mode)
However, there are certain internally-written programs that will run on the Windows only, so I run Parallels hypervisor with Windows 10 and Ubuntu.
On Windows 10, I have a hard time with the Command Prompt, last time I used DOS was in c. 1999, so I opted to try installing Bash.
$ ping Google.comPING Google.com (74.125.138.102) 56(84) bytes of data.
64 bytes from yi-in-f102.1e100.net (74.125.138.102): icmp_seq=1 ttl=128 time=30.4 ms
$ ssh dummy@74.125.138.102ssh: connect to host 74.125.138.102 port 22: Connection refused
Checking for Python
$ python --version
Command 'python' not found, but can be installed with:
sudo apt install python3
sudo apt install python
sudo apt install python-minimal
You also have python3 installed, you can run 'python3' instead.
$ python3 --version
Python 3.6.5
$ python3
Python 3.6.5 (default, Apr 1 2018, 05:46:30)
[GCC 7.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> print("Hello World")
Hello World
>>> exit()
$
Attempting to get Anaconda
wget https://3230d63b5fc54e62148e-c95ac804525aac4b6dba79b00b39d1d3.ssl.cf1.rackcdn.com/Anaconda-2.3.0-Linux-x86_64.sh-bash: .: Anaconda-2.3.0-Linux-x86_64.sh: cannot execute binary file
$ chmod +x Anaconda-2.3.0-Linux-x86_64.sh
$ . Anaconda-2.3.0-Linux-x86_64.sh
$ java
Command 'java' not found, but can be installed with:
$ sudo apt install default-jre
$ sudo apt install openjdk-11-jre-headless
$ sudo apt install openjdk-8-jre-headless
$ sudo apt install openjdk-11-jre-headless
$ java --versionopenjdk 10.0.1 2018-04-17
OpenJDK Runtime Environment (build 10.0.1+10-Ubuntu-3ubuntu1)
OpenJDK 64-Bit Server VM (build 10.0.1+10-Ubuntu-3ubuntu1, mixed mode)
Amazon remembers 30 of my past mobile devices!
It is funny, Amazon remembers 30 of my past mobile devices!
I had no idea until I have clicked for a new book to be delivered to my Kindle app.
Can you say I have been into mobile development since 2009?
I had no idea until I have clicked for a new book to be delivered to my Kindle app.
Can you say I have been into mobile development since 2009?
Amazon remembers 30 of my past mobile devices!
It is funny, Amazon remembers 30 of my past mobile devices!
I had no idea until I have clicked for a new book to be delivered to my Kindle app.
Can you say I have been into mobile development since 2009?
I had no idea until I have clicked for a new book to be delivered to my Kindle app.
Can you say I have been into mobile development since 2009?
graphlab.canvas.set_target('ipynb') error
I am getting an error in the following line:
graphlab.canvas.set_target('ipynb') # alternative 'browser', port=8889
graphlab.canvas.set_target('ipynb') # alternative 'browser', port=8889
/Volumes/DATA/anaconda3/envs/py27/lib/python2.7/site-packages/graphlab/canvas/server.pyc108 self.__server = tornado.httpserver.HTTPServer(self.__application, io_loop=self.__loop)TypeError: initialize() got an unexpected keyword argument 'io_loop'Fix Attempt 1:
$ conda update tornado
environment location: /Volumes/DATA/anaconda3/envs/py27
tornado: 5.1-py27h1de35cc_0 --> 5.1.1-py27h1de35cc_0
Fix is not successful
Fix Attempt 2:Reinstall Anaconda3
graphlab.canvas.set_target('ipynb') error
I am getting an error in the following line:
graphlab.canvas.set_target('ipynb') # alternative 'browser', port=8889
graphlab.canvas.set_target('ipynb') # alternative 'browser', port=8889
/Volumes/DATA/anaconda3/envs/py27/lib/python2.7/site-packages/graphlab/canvas/server.pyc
108 self.__server = tornado.httpserver.HTTPServer(self.__application, io_loop=self.__loop)
TypeError: initialize() got an unexpected keyword argument 'io_loop'Fix Attempt 1:
$ conda update tornadoenvironment location: /Volumes/DATA/anaconda3/envs/py27tornado: 5.1-py27h1de35cc_0 --> 5.1.1-py27h1de35cc_0Fix is not successfulFix Attempt 2:
Reinstall Anaconda3
Conda environment as a Jupyter Notebook kernel
Conda Environment as a Jupyter Notebook kernel
Update conda
$ conda activate base
$ conda update -n base -c defaults conda
$ conda update --all -y
Add conda tensorflow environment
$ conda create -n py_36_tf python=3.6 tensorflow -y
List currently installed Jupyther kernels
$ ls -alt ~/Library/Jupyter/kernels/
total 0
drwx------ 7 uki staff 224 Nov 22 11:50 ..
drwxr-xr-x 9 uki staff 288 Nov 22 11:43 .
drwxr-xr-x 5 uki staff 160 Nov 4 06:35 julia-1.4
drwxr-xr-x 5 uki staff 160 Apr 1 2020 python361064bitpy36condaa60168e76a7b4349b469299762ee4c30
drwxr-xr-x 5 uki staff 160 Apr 1 2020 python38264bitpytorchcondaaf5a833263b448b8b2738bb5a7355c8a
drwxr-xr-x 5 uki staff 160 Apr 1 2020 python361064bitturiconda565ecc262d0845fbb235ae21ac24296f
List conda environments you already created
$ conda info --envs
# conda environments:
#
/Users/uki/.julia/conda/3
base * /opt/anaconda3
py27 /opt/anaconda3/envs/py27
py36 /opt/anaconda3/envs/py36
py_36_tf /opt/anaconda3/envs/py_36_tf
pytorch /opt/anaconda3/envs/pytorch
tensorflow /opt/anaconda3/envs/tensorflow
turi /opt/anaconda3/envs/turi
Install new Jupyther kernel
$ python -m ipykernel install --user --name py_36_tf --display-name "Python 3.6 (tensorflow)"
Installed kernelspec py_36_tf in /Users/uki/Library/Jupyter/kernels/py_36_tf
Refresh a page with Jupyther Lab notebook and change to the new kernel.
Delete kernels that you want to replace
$ rm -r ~/Library/Jupyter/kernels/my_old_kernel_name
Install Anaconda Python environment with Jupyter Notebook
This post was updated on September 29, 2022
That is all you need to start working.
Alternatively, you may want to create ENVIRONMENT specific installation. This is useful if you work on multiple projects, especially over a long time when LIBRARIES change and code becomes outdated.
total 0
drwx------ 7 uki staff 224 Nov 22 11:50 ..
drwxr-xr-x 9 uki staff 288 Nov 22 11:43 .
drwxr-xr-x 5 uki staff 160 Nov 4 06:35 julia-1.4
drwxr-xr-x 5 uki staff 160 Apr 1 2020 python361064bitpy36condaa60168e76a7b4349b469299762ee4c30
drwxr-xr-x 5 uki staff 160 Apr 1 2020 python38264bitpytorchcondaaf5a833263b448b8b2738bb5a7355c8a
drwxr-xr-x 5 uki staff 160 Apr 1 2020 python361064bitturiconda565ecc262d0845fbb235ae21ac24296f
Installed kernelspec py_36_tf in /Users/uki/Library/Jupyter/kernels/py_36_tf
Check if you have Conda installed
% conda update --all -y
>> command not found: conda
Install Anaconda Python
I prefer an installer on my laptop:
After installation, make sure you restart the Terminal (control N).
Note, Anaconda includes the following and much more:
curl
numpy
matplotlib
jupyter_core
protobuf
sqlite
ipython
jupyterlab
jupyter
notebook
matplotlib
pip
pandas
pillow
scikit-learn
python-3.9
Update Conda
$ conda activate base$ conda update -n base -c defaults conda$ conda update --all -y
How to start Jupyter Notebook
cd $REPO // the directory you want as a base of your project (e.g. in GitHub directory)
jupyter-lab
This will start in the browser: http://localhost:8888/lab
That is all you need to start working.
Alternatively, you may want to create ENVIRONMENT specific installation. This is useful if you work on multiple projects, especially over a long time when LIBRARIES change and code becomes outdated.
Check Python Version that came with Conda
% python --version
Python 3.9.13
Create a Conda TensorFlow environment
$ conda create -n py_39_tf python=3.9 tensorflow -y
This installs tensorflow pkgs/main/osx-64::tensorflow-2.9.1
List conda environments you already created
$ conda info --envs
% conda info --envs
# conda environments:
#
base * /Users/uki/opt/anaconda3
py_39_tf /Users/uki/opt/anaconda3/envs/py_39_tf
Activate the Conda Environment you want Jupyter in.
% conda activate py_39_tf
(py_39_tf) uki ~ %
Install new Jupyther kernel
$ python -m ipykernel install --user --name py_36_tf --display-name "Python 3.6 (tensorflow)"
List currently installed Jupyther kernels
$ ls -alt ~/Library/Jupyter/kernels/
total 0
drwx------ 7 uki staff 224 Nov 22 11:50 ..
drwxr-xr-x 9 uki staff 288 Nov 22 11:43 .
drwxr-xr-x 5 uki staff 160 Nov 4 06:35 julia-1.4
drwxr-xr-x 5 uki staff 160 Apr 1 2020 python361064bitpy36condaa60168e76a7b4349b469299762ee4c30
drwxr-xr-x 5 uki staff 160 Apr 1 2020 python38264bitpytorchcondaaf5a833263b448b8b2738bb5a7355c8a
drwxr-xr-x 5 uki staff 160 Apr 1 2020 python361064bitturiconda565ecc262d0845fbb235ae21ac24296f
Installed kernelspec py_36_tf in /Users/uki/Library/Jupyter/kernels/py_36_tf
Refresh a page with Jupyther Lab notebook and change to the new kernel.
Delete kernels that you want to replace
$ rm -r ~/Library/Jupyter/kernels/my_old_kernel_name
Microsoft Excel spreadsheet creates 1,048,576 rows!
I am sorry Microsoft, I really thought you have improved, but sometimes you just amaze me...
I bought my own Office license, so I am a paying customer.
The Excel creates 1,048,576 rows and yes, this brings the spreadsheet to a holt.
I am not making this up, there is an official post on it:
https://support.office.com/en-us/article/Locate-and-reset-the-last-cell-on-a-worksheet-C9E468A8-0FC3-4F69-8038-B3C1D86E99E9
The question is why in the world would you do it to a new spreadsheet with a few rows of actual data?
- Select the first EMPTY row.
Depending on your keyboard you can use the following key combination:
- SHIFT + CONTROL + Arrow DOWN
or
- Control + END
- Right click and select DELETE
IT WORKS, then it recreated 1,048,576 rows!
The developer who created this functionality should be forced to do some very unpleasant things for each row created.
I have used it, but I think it is stupid, the rows are still there.
Please share and donate!
I bought my own Office license, so I am a paying customer.
The Excel creates 1,048,576 rows and yes, this brings the spreadsheet to a holt.
I am not making this up, there is an official post on it:
https://support.office.com/en-us/article/Locate-and-reset-the-last-cell-on-a-worksheet-C9E468A8-0FC3-4F69-8038-B3C1D86E99E9
The question is why in the world would you do it to a new spreadsheet with a few rows of actual data?
Force-killing frozen Excel
Re-opening the Excel reveals the same condition.Select and Delete All Empty Rows
You can select and delete all rows below your last row with data.- Select the first EMPTY row.
Depending on your keyboard you can use the following key combination:
- SHIFT + CONTROL + Arrow DOWN
or
- Control + END
- Right click and select DELETE
IT WORKS, then it recreated 1,048,576 rows!
The developer who created this functionality should be forced to do some very unpleasant things for each row created.
Hiding millions of rows and columns
Some people suggest to select and hide the offending rows and columns (to the right).I have used it, but I think it is stupid, the rows are still there.
Select and Clear All Empty Rows
Since the cells were auto-generated, I am not sure why the article is suggesting this, but I tried this too.
- Select all empty cells (same as above)
- Right click and "Clear Contents"
- Save file
- Close
- Open file
No difference
Try #2
- Select all empty cells (same as above)
- Home > Clear > Clear All
- Save file
- Close
- Open file
No difference
The file on the disk is 29.5 MB
The Best Solution
- Select ALL POPULATED cells
- Open Apple Numbers
- paste cells
- Export file to Excel when you have to send it to coworkers
The file on the disk is 8 kB
Please share and donate!
Microsoft Excel spreadsheet creates 1,048,576 rows!
I am sorry Microsoft, I really thought you have improved, but sometimes you just amaze me...
I bought my own Office license, so I am a paying customer.
The Excel creates 1,048,576 rows and yes, this brings the spreadsheet to a holt.
I am not making this up, there is an official post on it:
https://support.office.com/en-us/article/Locate-and-reset-the-last-cell-on-a-worksheet-C9E468A8-0FC3-4F69-8038-B3C1D86E99E9
The question is why in the world would you do it to a new spreadsheet with a few rows of actual data?
- Select the first EMPTY row.
Depending on your keyboard you can use the following key combination:
- SHIFT + CONTROL + Arrow DOWN
or
- Control + END
- Right click and select DELETE
IT WORKS, then it recreated 1,048,576 rows!
The developer who created this functionality should be forced to do some very unpleasant things for each row created.
I have used it, but I think it is stupid, the rows are still there.
Please share and donate!
I bought my own Office license, so I am a paying customer.
The Excel creates 1,048,576 rows and yes, this brings the spreadsheet to a holt.
I am not making this up, there is an official post on it:
https://support.office.com/en-us/article/Locate-and-reset-the-last-cell-on-a-worksheet-C9E468A8-0FC3-4F69-8038-B3C1D86E99E9
The question is why in the world would you do it to a new spreadsheet with a few rows of actual data?
Force-killing frozen Excel
Re-opening the Excel reveals the same condition.Select and Delete All Empty Rows
You can select and delete all rows below your last row with data.- Select the first EMPTY row.
Depending on your keyboard you can use the following key combination:
- SHIFT + CONTROL + Arrow DOWN
or
- Control + END
- Right click and select DELETE
IT WORKS, then it recreated 1,048,576 rows!
The developer who created this functionality should be forced to do some very unpleasant things for each row created.
Hiding millions of rows and columns
Some people suggest to select and hide the offending rows and columns (to the right).I have used it, but I think it is stupid, the rows are still there.
Select and Clear All Empty Rows
Since the cells were auto-generated, I am not sure why the article is suggesting this, but I tried this too.
- Select all empty cells (same as above)
- Right click and "Clear Contents"
- Save file
- Close
- Open file
No difference
Try #2
- Select all empty cells (same as above)
- Home > Clear > Clear All
- Save file
- Close
- Open file
No difference
The file on the disk is 29.5 MB
The Best Solution
- Select ALL POPULATED cells
- Open Apple Numbers
- paste cells
- Export file to Excel when you have to send it to coworkers
The file on the disk is 8 kB
Please share and donate!
Jupyter TOC
In order to create a Table of Contents in Jupyter Notebook, you need anchor tags above the headings:
replace_record
">
## Table of Contents
1. [Reading the CSV file](#Reading-CSV-file)
1. [The article's HTML template](#template)
1. [Main part - replace for every record](#replace_record)
replace_record
">
## Table of Contents
1. [Reading the CSV file](#Reading-CSV-file)
1. [The article's HTML template](#template)
1. [Main part - replace for every record](#replace_record)
Jupyter TOC
In order to create a Table of Contents in Jupyter Notebook, you need anchor tags above the headings:
replace_record
">
## Table of Contents
1. [Reading the CSV file](#Reading-CSV-file)
1. [The article's HTML template](#template)
1. [Main part - replace for every record](#replace_record)
replace_record
">
## Table of Contents
1. [Reading the CSV file](#Reading-CSV-file)
1. [The article's HTML template](#template)
1. [Main part - replace for every record](#replace_record)
Chrome Refresh
Caching of old content in the browser can drive you nuts when you develop HTML pages.
On Mac Google Chrome you refresh bypassing the cache by:
Holding both the ⌘ Cmd and ⇧ Shift keys and pressing the R key.
On Mac Google Chrome you refresh bypassing the cache by:
Holding both the ⌘ Cmd and ⇧ Shift keys and pressing the R key.
Chrome Refresh
Caching of old content in the browser can drive you nuts when you develop HTML pages.
On Mac Google Chrome you refresh bypassing the cache by:
Holding both the ⌘ Cmd and ⇧ Shift keys and pressing the R key.
On Mac Google Chrome you refresh bypassing the cache by:
Holding both the ⌘ Cmd and ⇧ Shift keys and pressing the R key.
PCA9685
pip install Adafruit-PCA9685
References:
https://learn.adafruit.com/adafruit-16-channel-servo-driver-with-raspberry-pi/overview
PCA9685
pip install Adafruit-PCA9685
References:
https://learn.adafruit.com/adafruit-16-channel-servo-driver-with-raspberry-pi/overview
As an Amazon Associate I earn from qualifying purchases.
As an Amazon Associate I earn from qualifying purchases.
Ubiquity Robotics Ubuntu Pi image for Pi with ROS
Ubiquity Robotics Lubuntu Pi image for Pi
On Ubuntu OS:
sudo apt install gnome-disk-utility
On Mac OS:
https://etcher.io/
Raspberry Pi 3 Model B
User :Ubuntu
Password: ubuntu (please change)
Pi HotSpot:
SSID is ubiquityrobotXXXX
where XXXX is part of the MAC address
Password: robotseverywhere
$ ssh ubuntu@192.168.50.16
The authenticity of host '192.168.50.16 (192.168.50.16)' can't be established.
ECDSA key fingerprint is SHA256:xq7SSuVwuVdifKaZGNqgt09LiDiZ0cnayd1tp4kWzD4.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.50.16' (ECDSA) to the list of known hosts.
ubuntu@192.168.50.16's password:
Welcome to Ubuntu 16.04.4 LTS (GNU/Linux 4.9.80-v7+ armv7l)
* Documentation: https://help.ubuntu.com
* Management: https://landscape.canonical.com
* Support: https://ubuntu.com/advantage
464 packages can be updated.
140 updates are security updates.
...
ubuntu@ubiquityrobot:~$ sudo apt-get update
[sudo] password for ubuntu:
ubuntu@ubiquityrobot:~$ sudo apt-get upgrade
E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
Disable the Ubiquity Robotics scripts (unless you run their robots):
$ sudo systemctl disable magni-base
Removed symlink /etc/systemd/system/multi-user.target.wants/magni-base.service.
On Ubuntu OS:
sudo apt install gnome-disk-utility
On Mac OS:
https://etcher.io/
Raspberry Pi 3 Model B
User :Ubuntu
Password: ubuntu (please change)
Pi HotSpot:
SSID is ubiquityrobotXXXX
where XXXX is part of the MAC address
Password: robotseverywhere
$ ssh ubuntu@192.168.50.16
The authenticity of host '192.168.50.16 (192.168.50.16)' can't be established.
ECDSA key fingerprint is SHA256:xq7SSuVwuVdifKaZGNqgt09LiDiZ0cnayd1tp4kWzD4.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.50.16' (ECDSA) to the list of known hosts.
ubuntu@192.168.50.16's password:
Welcome to Ubuntu 16.04.4 LTS (GNU/Linux 4.9.80-v7+ armv7l)
* Documentation: https://help.ubuntu.com
* Management: https://landscape.canonical.com
* Support: https://ubuntu.com/advantage
464 packages can be updated.
140 updates are security updates.
...
ubuntu@ubiquityrobot:~$ sudo apt-get update
[sudo] password for ubuntu:
ubuntu@ubiquityrobot:~$ sudo apt-get upgrade
E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
$ sudo systemctl disable magni-base
Removed symlink /etc/systemd/system/multi-user.target.wants/magni-base.service.
References:
https://ubuntu-pi-flavour-maker.org/
Ubiquity Robotics Lubuntu Pi image for Pi:
Ubiquity Robotics Ubuntu Pi image for Pi with ROS
Ubiquity Robotics Lubuntu Pi image for Pi
On Ubuntu OS:
sudo apt install gnome-disk-utility
On Mac OS:
https://etcher.io/
Raspberry Pi 3 Model B
User :Ubuntu
Password: ubuntu (please change)
Pi HotSpot:
SSID is ubiquityrobotXXXX
where XXXX is part of the MAC address
Password: robotseverywhere
E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
Disable the Ubiquity Robotics scripts (unless you run their robots):
On Ubuntu OS:
sudo apt install gnome-disk-utility
On Mac OS:
https://etcher.io/
Raspberry Pi 3 Model B
User :Ubuntu
Password: ubuntu (please change)
Pi HotSpot:
SSID is ubiquityrobotXXXX
where XXXX is part of the MAC address
Password: robotseverywhere
$ ssh ubuntu@192.168.50.16
The authenticity of host '192.168.50.16 (192.168.50.16)' can't be established.
ECDSA key fingerprint is SHA256:xq7SSuVwuVdifKaZGNqgt09LiDiZ0cnayd1tp4kWzD4.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.50.16' (ECDSA) to the list of known hosts.
ubuntu@192.168.50.16's password:
Welcome to Ubuntu 16.04.4 LTS (GNU/Linux 4.9.80-v7+ armv7l)
* Documentation: https://help.ubuntu.com
* Management: https://landscape.canonical.com
* Support: https://ubuntu.com/advantage
464 packages can be updated.
140 updates are security updates.
...
How to update Ubuntu from the command line?
ubuntu@ubiquityrobot:~$ sudo apt-get update
[sudo] password for ubuntu:
ubuntu@ubiquityrobot:~$ sudo apt-get upgrade
E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
$ sudo systemctl disable magni-base
Removed symlink /etc/systemd/system/multi-user.target.wants/magni-base.service.
References
https://ubuntu-pi-flavour-maker.org/
Ubiquity Robotics Lubuntu Pi image for Pi:
Python template
To replace tokens in the HTML template I use method str.format()
line3 = ' {ARTICLE_TITLE}'
line3 = line3.format(ARTICLE_URL="http...", ARTICLE_TITLE="My Note")
print( line3 )
line3 = ' {ARTICLE_TITLE}'
line3 = line3.format(ARTICLE_URL="http...", ARTICLE_TITLE="My Note")
print( line3 )
My Note'
Python template
To replace tokens in the HTML template I use method str.format()
line3 = ' {ARTICLE_TITLE}'
line3 = line3.format(ARTICLE_URL="http...", ARTICLE_TITLE="My Note")
print( line3 )
line3 = ' {ARTICLE_TITLE}'
line3 = line3.format(ARTICLE_URL="http...", ARTICLE_TITLE="My Note")
print( line3 )
My Note'
GitHub gitignore
Sometimes the .gitignore file does not work with GitHub, to fix it I execute the following:
$ git rm -r --cached .
$ git commit -a -m "fixed .gitignore"
GitHub gitignore
Sometimes the .gitignore file does not work with GitHub, to fix it I execute the following:
$ git rm -r --cached .
$ git commit -a -m "fixed .gitignore"
Remove commit
Sometimes when you COMMIT to GitHub a file larger than 100MB, the PUSH is rejected.
Your branch is ahead of 'origin/master' by 5 commits.
You have to remove the last (or more) COMMIT, the following command does not change your code:
git reset --soft HEAD~1
Then fix the problem, usually by marking the large files in .gitignore
$ git commit -a -m "added gitignore with _DATA/* directory"
$ git status
Untracked files:
(use "git add..." to include in what will be committed)
src/_DATA/amazon_baby.csv
src/_DATA/amazon_baby.gl/
src/_DATA/home_data.gl/
src/_DATA/image_test_data/
src/_DATA/image_train_data/
src/_DATA/people-example.csv
src/_DATA/people_wiki.csv
src/_DATA/people_wiki.gl/
src/_DATA/song_data.csv
src/_DATA/song_data.gl/
Then push again and pray:
Your branch is ahead of 'origin/master' by 5 commits.
You have to remove the last (or more) COMMIT, the following command does not change your code:
git reset --soft HEAD~1
Then fix the problem, usually by marking the large files in .gitignore
$ git commit -a -m "added gitignore with _DATA/* directory"
$ git status
Untracked files:
(use "git add
src/_DATA/amazon_baby.csv
src/_DATA/amazon_baby.gl/
src/_DATA/home_data.gl/
src/_DATA/image_test_data/
src/_DATA/image_train_data/
src/_DATA/people-example.csv
src/_DATA/people_wiki.csv
src/_DATA/people_wiki.gl/
src/_DATA/song_data.csv
src/_DATA/song_data.gl/
Then push again and pray:
$ git push
$ git status
On branch master
Your branch is up to date with 'origin/master'
Remove commit
Sometimes when you COMMIT to GitHub a file larger than 100MB, the PUSH is rejected.
Your branch is ahead of 'origin/master' by 5 commits.
You have to remove the last (or more) COMMIT, the following command does not change your code:
git reset --soft HEAD~1
Then fix the problem, usually by marking the large files in .gitignore
$ git commit -a -m "added gitignore with _DATA/* directory"
$ git status
Untracked files:
(use "git add..." to include in what will be committed)
src/_DATA/amazon_baby.csv
src/_DATA/amazon_baby.gl/
src/_DATA/home_data.gl/
src/_DATA/image_test_data/
src/_DATA/image_train_data/
src/_DATA/people-example.csv
src/_DATA/people_wiki.csv
src/_DATA/people_wiki.gl/
src/_DATA/song_data.csv
src/_DATA/song_data.gl/
Then push again and pray:
Your branch is ahead of 'origin/master' by 5 commits.
You have to remove the last (or more) COMMIT, the following command does not change your code:
git reset --soft HEAD~1
Then fix the problem, usually by marking the large files in .gitignore
$ git commit -a -m "added gitignore with _DATA/* directory"
$ git status
Untracked files:
(use "git add
src/_DATA/amazon_baby.csv
src/_DATA/amazon_baby.gl/
src/_DATA/home_data.gl/
src/_DATA/image_test_data/
src/_DATA/image_train_data/
src/_DATA/people-example.csv
src/_DATA/people_wiki.csv
src/_DATA/people_wiki.gl/
src/_DATA/song_data.csv
src/_DATA/song_data.gl/
Then push again and pray:
$ git push
$ git status
On branch master
Your branch is up to date with 'origin/master'
GitHub SSH
Go to:
https://gist.github.com/developius/c81f021eb5c5916013dc
$ ssh -T git@github.com
The authenticity of host 'github.com (192.30.253.112)' can't be established.
RSA key fingerprint is SHA256:nTh....
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'github.com,1xx.xx.xx.xx' (RSA) to the list of known hosts.
Enter passphrase for key '/Users/uki/.ssh/id_rsa':
Hi UkiDLucas! You've successfully authenticated, but GitHub does not provide shell access.
$ ssh -T git@github.com
The authenticity of host 'github.com (192.30.253.112)' can't be established.
RSA key fingerprint is SHA256:nTh....
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'github.com,1xx.xx.xx.xx' (RSA) to the list of known hosts.
Enter passphrase for key '/Users/uki/.ssh/id_rsa':
Hi UkiDLucas! You've successfully authenticated, but GitHub does not provide shell access.
Subscribe to:
Comments (Atom)
Popular Recent Posts
-
Keishin Kata (敬心形) of Shobudo (正武道) karate kei (敬) respect, reverence, or honor someone or something shin (心) heart or mind kata (形) fo... -
Before arriving in Okinawa, several experiences prepared me for what I would eventually learn there. Karate was the first. It introduced me ...
-
I came across Ruri Ohama mentioning a book by Takafumi Horie and Yoichi Ochiai titled: “Job Atlas for 10 Years From Now. How Will You Live i...
-
Please look at the newer post: http://ukitech.blogspot.com/2009/09/eclipse-35-galileo-and-gwt-m2-svn.html 1) Upload a new version of Eclipse... -
I have a habit of "stopping to smell the roses", or as in today's case, to take a photo of baby mushrooms on the forest floor.... -
http://code.google.com/apis/socialgraph/
-
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space or Unable to execute dex: Java heap space Java h... -
Step 1: Register you app with Facebook. Sign in to Facebook using your standard credentials. Navigate to http://www.facebook.com/developer... -
Many online videos warn about vegetables you should never eat, especially those rich in oxalates. The tone is dramatic. The reality is much ...
Most Popular Articles
-
Affordance as a Function of Intent and Action? As a person passionate about Behavioral Sciences, I found myself unable to shake the impre...
-
Step 1: Register you app with Facebook. Sign in to Facebook using your standard credentials. Navigate to http://www.facebook.com/developer...
-
Please look at the newer post: http://ukitech.blogspot.com/2009/09/eclipse-35-galileo-and-gwt-m2-svn.html 1) Upload a new version of Eclipse...
-
Creating Android ROS nodes to: - add control UI (HMI) - utilize existing phone sensors: -- gyroscope -- GPS -- compass -- camera - do...
-
In this tutorial we will learn how to install the Intellij IDEA database plugin. Start with opening Settings > search for plugins ... -
Installing TuriCreate on Python 3.6 Anaconda Environment 1) Check what Python version Apple Turi Create supports https://github.com/ap...
-
In this tutorial we will overview integration basics of Android Studio and Gradle build tools. -
This tutorial shows you how to change the code lower/upper case of code in Android Studio.
-
ImportError : No module named 'sklearn.model_selection' Before doing the embarrassing things I did below, read this: Setting Jupy...
-
This minimal PyTorch example implements a custom recurrent neural network (RNN) cell from first principles, showing how sequence memory eme...
