- 博客(8)
- 收藏
- 关注
原创 HackerRank - SQL
Basic Select & Advanced Select1. Weather Observation Station 5Query 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 366
原创 E4523 Network
+ Networks are connected bi-directional graphs+ Nodes mark the entities in a network+ Edges mark the relationships in a networkShortest path between two nodes Connectedness Centrality closeness; betweenness Clustering Communicability1. Networkx.
2021-12-14 06:14:21 215
原创 E4523 Pandas
1. DateTimedate: 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 objects1.1 datetime.
2021-12-12 01:06:26 747
原创 E4523 Data Visualization
目录1. Grouped Data1.1 Group一次1.2 Group两次1.3 选择TOP5制图1.4 时间统计处理2. Distribution2.1 画statistical function2.2 画拟合distribution3. Mapping1. Grouped Data%matplotlib inlineimport matplotlib.pyplot as pltplt.style.use('seaborn')1.1 G...
2021-12-11 11:10:15 165
原创 Final Sample
Q1: Map Visualization of density by neighborhood1. 导入库,初始化import pandas as pdimport numpy as npimport foliumimport jsonimport geojsoniofile='nyc_zip_borough_neighborhoods_pop.csv'df = pd.read_csv(file)2. 通过groupby处理数据,根据 密度=人口/面积,计算neighbor的密度
2021-12-01 11:31:15 90
原创 E4523 Text Mining
Sentiment Analysis#Example 1: Compute the proportion of positive and negative words in a text.1.获得pos/neg词setdef get_pos_neg_words(): def get_words(url): import requests words = requests.get(url).content.decode('latin-1')
2021-12-01 04:48:30 649
原创 E4523 Machine Learning
目录Regression [S]Classification & Regression Trees (CART) [S]Neural Network [S]Regression [S]Linear Regression (Classification to Binomial Categories)1. Read dataimport pandas as pdfrom pandas import DataFrameurl="https://archive.ics.uc
2021-11-19 04:15:53 551
原创 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 1081
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人