- 博客(8)
- 收藏
- 关注
原创 HackerRank - SQL
Basic Select & Advanced Select 1. Weather Observation Station 5 Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest
2022-02-06 03:09:26 343
原创 E4523 Network
+ Networks are connected bi-directional graphs + Nodes mark the entities in a network + Edges mark the relationships in a network Shortest path between two nodes Connectedness Centrality closeness; betweenness Clustering Communicability 1. Networkx.
2021-12-14 06:14:21 203
原创 E4523 Pandas
1. DateTime date: stores the date (month,day,year) time: stores the time (hours,minutes,seconds) datetime: stores the date as well as the time (month,day,year,hours,minutes,seconds) timedelta: duration between two datetime or date objects 1.1 datetime.
2021-12-12 01:06:26 737
原创 E4523 Data Visualization
目录 1. Grouped Data 1.1 Group一次 1.2 Group两次 1.3 选择TOP5制图 1.4 时间统计处理 2. Distribution 2.1 画statistical function 2.2 画拟合distribution 3. Mapping 1. Grouped Data %matplotlib inline import matplotlib.pyplot as plt plt.style.use('seaborn') 1.1 G...
2021-12-11 11:10:15 156
原创 Final Sample
Q1: Map Visualization of density by neighborhood 1. 导入库,初始化 import pandas as pd import numpy as np import folium import json import geojsonio file='nyc_zip_borough_neighborhoods_pop.csv' df = pd.read_csv(file) 2. 通过groupby处理数据,根据 密度=人口/面积,计算neighbor的密度
2021-12-01 11:31:15 81
原创 E4523 Text Mining
Sentiment Analysis #Example 1: Compute the proportion of positive and negative words in a text. 1.获得pos/neg词set def get_pos_neg_words(): def get_words(url): import requests words = requests.get(url).content.decode('latin-1')
2021-12-01 04:48:30 635
原创 E4523 Machine Learning
目录 Regression [S] Classification & Regression Trees (CART) [S] Neural Network [S] Regression [S] Linear Regression (Classification to Binomial Categories) 1. Read data import pandas as pd from pandas import DataFrame url="https://archive.ics.uc
2021-11-19 04:15:53 543
原创 Leetcode Database -MySQL [American Station]
2021.10.6 开始刷Database-MySQL,小白刷题,争取每天打卡记录。 175.Combine Two Tables [E] Write an SQL query to report the first name, last name, city, and state of each person in thePersontable. If the address of aPersonIdis not present in theAddresstable, reportnu...
2021-10-07 03:00:49 997
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人