From junior to geek the road is sleek
admin 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))
Best way is to use Panda’s to_csv() built-in function df.to_csv(‘filename’, index=False) Don’t forget to pass index=False as a second parameter if you don’t want index row saved as a column (in other words use it if you don’t want duplicated index when opening the file again). By the way, you can also withhold column names … Read more