Skip to content

Instantly share code, notes, and snippets.

View paulozullu's full-sized avatar
🏠
Working from home

Paulo Fabrício paulozullu

🏠
Working from home
View GitHub Profile
@paulozullu
paulozullu / age_21.py
Last active February 26, 2016 17:48
Using pyneo, get users that has 21 years old
#-*- coding: utf-8 -*-
'''
Created on 25 de fev de 2016
'''
from py2neo import Graph, authenticate
import datetime
from dateutil.relativedelta import relativedelta
now = datetime.datetime.now()
@paulozullu
paulozullu / age_between21_30.py
Last active February 26, 2016 17:48
Using pyneo, get users that have between 21 and 30 years old
#-*- coding: utf-8 -*-
'''
Created on 25 de fev de 2016
'''
from py2neo import Graph, authenticate
import datetime
from dateutil.relativedelta import relativedelta
now = datetime.datetime.now()
@paulozullu
paulozullu / age_more21.py
Last active February 26, 2016 17:48
Using pyneo, get users that have more than 21 years old
#-*- coding: utf-8 -*-
'''
Created on 25 de fev de 2016
'''
from py2neo import Graph, authenticate
import datetime
from dateutil.relativedelta import relativedelta
now = datetime.datetime.now()
@paulozullu
paulozullu / age_under21.py
Last active February 26, 2016 17:48
Using pyneo, get users that have less than 21 years old
#-*- coding: utf-8 -*-
'''
Created on 25 de fev de 2016
'''
from py2neo import Graph, authenticate
import datetime
from dateutil.relativedelta import relativedelta
now = datetime.datetime.now()
@paulozullu
paulozullu / birthday_this_week.py
Last active February 26, 2016 17:47
Using pyneo, get users whose birthday is this week
#-*- coding: utf-8 -*-
'''
Created on 25 de fev de 2016
'''
from py2neo import Graph, authenticate
import datetime
now = datetime.datetime.now()
year = datetime.date.today().year
@paulozullu
paulozullu / birthday_last_week.py
Last active February 26, 2016 17:46
Using pyneo, get users whose birthday was last week
#-*- coding: utf-8 -*-
'''
Created on 25 de fev de 2016
'''
from py2neo import Graph, authenticate
import datetime
now = datetime.datetime.now()
year = datetime.date.today().year
@paulozullu
paulozullu / category_city_age.py
Last active February 26, 2016 18:01
With pyneo, get users whose first category of preference is sports, live in São Paulo and are males between 18 and 32 years old​
#-*- coding: utf-8 -*-
'''
Created on 25 de fev de 2016
'''
from py2neo import Graph, authenticate
import datetime
from dateutil.relativedelta import relativedelta
now = datetime.datetime.now()
@paulozullu
paulozullu / mongo.MD
Last active February 2, 2023 20:52
Mongo

Commands

1 - Select database

use db_name

2 - Show collections

show collections

@paulozullu
paulozullu / unique_followers_db.py
Created July 7, 2016 22:46
Get unique followers rate for Twitter
# -*- coding: utf-8 -*-
"""
Created on Thu Jul 7 18:58:34 2016
@author: paulozullu
"""
from pymongo import MongoClient
''' Creates a connection to MongoDB '''
def connect_mongo(server, db):
@paulozullu
paulozullu / subject.cy
Last active September 28, 2016 12:58
Cypher to calculate subjects
MATCH ()-[n2:NEXT]-(w:Word)
WITH w, COUNT(n2) AS DEGREE, SUM(n2.count) AS STRENGTH
ORDER BY w.name
RETURN w, DEGREE, STRENGTH, toFloat(STRENGTH)/toFloat(DEGREE) AS SELECTIVITY