http://www.commres.net/ 2026-04-17T10:44:01+00:00 http://www.commres.net/ http://www.commres.net/_media/wiki/logo.png text/html 2017-09-08T08:00:27+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.commres.net/notes/python?rev=1504857627&do=diff <https://www.coursera.org/specializations/data-science-python#courses> Syllabus: Applied Data Science with Python * basic recommendation Programming for Everybody * python basic * the pandas toolkit * Advanced Querying and data manipulation using pandas * Statistical Analysis with nuimpy and scipy * programmers, * behavioral scientists and * data scientists * text/html 2015-03-25T05:00:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.commres.net/notes/sql?rev=1427259612&do=diff SELECT DISTINCT(u1.ID), u1.user_email, u1.display_name, m1.meta_value AS fristname, m2.meta_value AS lastname, m3.meta_value AS description from net_users u1 JOIN net_usermeta m1 ON (m1.user_id=u1.ID AND m1.meta_key='first_name') JOIN net_usermeta m2 ON (m2.user_id=u1.ID AND m2.meta_key='last_name') JOIN net_usermeta m3 ON (m3.user_id=u1.ID AND m3.meta_key='description')