From junior to geek the road is sleek
admin The ‘www-data’ is the default user of Nginx and Apache servers on Ubuntu system. That’s why when we need to serve some files or CMS with Nginx we change the ownership of the folder to: www-data:www-data If you are wondering why there’s 2 ‘www-data’ separated by colon, it’s because first is the username and second … Read more
Hey guys and gals, I’m back! =) Lately I’ve been deploying WordPress on Ubuntu servers with nginx quite often. It’s not complicated at all when you got the hang of it but can be a little bit overwhelming at first. So I decided to create a step-by-step tutorial for you guys. First off we need … Read more
Create database: CREATE DATABASE database1; Create user CREATE USER user IDENTIFIED BY ‘secure_password’; Grant all privileges on specific database: GRANT ALL PRIVILEGES ON database1.* TO user; Show all users: SELECT User FROM mysql.user; Show all databases: SHOW DATABASES; Delete user: DROP User ‘user’@’localhost’; Remove database: DROP DATABASE YourDatabase; Reload the GRANT tables to enable the … Read more
Hello, I’m back! 😎 Now the traditional method is this: df.loc[df[‘column_name’] == value] For string, and for numeric values this: df.loc[df[‘column_name’] == ‘string’] While it always work with numeric values, for string values sometimes it doesn’t work. It picks up a blank dataframe. I guess it’s something to do with encoding of the source where … Read more
I’ve been researching the web for this topic for a couple of hours and came to a conclusion that savvy programmers prefer CentOS for running their MySql and other databases. Here’s an interesting poll. Yes, it’s dated but still, all the fresh info I found on this topic tend to stick with the same choice. … Read more
The quickest way to find out is to type: cat /etc/*-release in my case the result is: CentOS Linux release 8.3.2011 NAME=”CentOS Linux” VERSION=”8″ ID=”centos” ID_LIKE=”rhel fedora” VERSION_ID=”8″ PLATFORM_ID=”platform:el8″ PRETTY_NAME=”CentOS Linux 8″ ANSI_COLOR=”0;31″ CPE_NAME=”cpe:/o:centos:centos:8″ HOME_URL=”https://centos.org/” BUG_REPORT_URL=”https://bugs.centos.org/” CENTOS_MANTISBT_PROJECT=”CentOS-8″ CENTOS_MANTISBT_PROJECT_VERSION=”8″ CentOS Linux release 8.3.2011 CentOS Linux release 8.3.2011 If you are interested what command cat /etc/*-release means … Read more
with open(‘C:/path/filename.txt’) as f: lines = f.read().splitlines()
I love list comprehensions. I really do. And it’s time for list comprehensions! If you need to withhold all items from a list1 that are present in list2 – nothing else works better! There we go, beautiful & clean code: list1 = [‘banana’, ‘orange’, ‘apple’, ‘apple’, ‘lemon’, ‘strawberry’, ‘pineapple’, ‘melon’, ‘melon’, ‘peach’, ‘pear’] list2 = … Read more
Do you also get weird signs like ‘\x00s\x00v\x00e\x00n\x00l\x00o’ when reading data from file? It’s because UTF-16 encoding. You should decode it. Here’s the solution: import codecs filename = ‘yourFileName.txt’ with codecs.open(filename, “r”, “utf-16”) as f: data = f.read().splitlines() print(data)
The easiest way to do this: import time start = time.time() Print(“Starting script execution…”) end = time.time() execution_time = end – start print(“Execution time = ” + str(execution_time))