Tag Archives: MySQL

Use MySQL database in Python

PyMySQL its a pure python client library, you can install using pip install PyMySQL (find documentation at https://pymysql.readthedocs.io/en/latest/). The following is a simple example to demonstrate how to use the library. #!/usr/bin/env python from __future__ import print_function import pymysql conn … Continue reading

Share
Posted in MySQL, Python | Tagged , , | Leave a comment

Search turning points in the trading history of a stock

Stock prices fluctuate everyday. It is impossible to pinpoint the bottom or peak of a stock. But by analyzing the trading history of a stock, we can figure a some unusual signals in the trading history of a stock. By … Continue reading

Share
Posted in MySQL, R/S-Plus, Tutorial | Tagged , , , , | Leave a comment

R import MySQL data tables

R language is free. Its functions are very powerful. It can be used to do all kinds of data analysis and plot drawing. I always use MySQL database to manage my data. R has the capability to read data from … Continue reading

Share
Posted in R/S-Plus, Tips | Tagged , | Leave a comment

MySQL transpose function of aggregation

An article published at the following providing a lot of examples. http://www.artfulsoftware.com/infotree/queries.php At the stackoverflow website there is an example as below. It helps me a lot. The following text from the site. Question: Here is what my current mysql … Continue reading

Share
Posted in MySQL | Tagged , , , , | Leave a comment

GROUP domain from url in MySql

Problem I have a large database that contains many urls, there are many domains repeating and i;m trying to get only the domain. eg: http://example.com/someurl.html http://example.com/someurl_on_the_same_domain.html http://example.net/myurl.php http://example.org/anotherurl.php and i want to get only domains, eg: http://example.com http://example.net http://example.org My … Continue reading

Share
Posted in MySQL | Tagged , , | Leave a comment