We can't make this file beautiful and searchable because it's too large.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
column_1,column_2,column_3 | |
0.7507948164964069,0.40767348076503473,0.91783846705252 | |
0.05683693902687936,0.8344249581421073,0.7885197628797966 | |
0.9685621728865862,0.22322042242735474,0.32994729101423526 | |
0.7659091410107962,0.947624247623736,0.4568907937800606 | |
0.6329713077294552,0.16049635159859943,0.6733334852337765 | |
0.9428937785927056,0.6121576359303711,0.20406187577429125 | |
0.09783514741019594,0.3285568881694171,0.8315536948478751 | |
0.9521955853297526,0.6903355601203242,0.24722661365470522 | |
0.7105871742243044,0.8453069857309263,0.7960150266517927 |
We can't make this file beautiful and searchable because it's too large.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
column_1,column_2,column_3 | |
0.9840313490055554,0.8237162587873815,0.1961040502221134 | |
0.9188675216732579,0.23782967194338533,0.6133996316896547 | |
0.8965042232340755,0.5069027719247561,0.3894070527440623 | |
0.03279837847481504,0.6948257199760983,0.46548265434759306 | |
0.7303764162792399,0.7721719415813256,0.4864749010964726 | |
0.41721716381954765,0.20299189725497913,0.6091806559537448 | |
0.09705379991212815,0.5067258470071659,0.4747831252142545 | |
0.6150856665778249,0.6726491935789671,0.9444189755239045 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"vim.normalModeKeyBindings": [ | |
{ | |
"before": ["J"], | |
"after": ["5", "j"] | |
}, | |
{ | |
"before": ["K"], | |
"after": ["5", "k"] | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Write an SQL query to report the second highest salary from the Employee table. If there is no second highest salary, the query should report null. | |
*/ | |
WITH rank_table AS ( | |
SELECT | |
salary, | |
dense_rank() OVER ( | |
order by | |
salary desc | |
) as rnk |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Julia asked her students to create some coding challenges. Write a query to print the hacker_id, name, and the total number of challenges created by each student. Sort your results by the total number of challenges in descending order. If more than one student created the same number of challenges, then sort the result by hacker_id. If more than one student created the same number of challenges and the count is less than the maximum number of challenges created, then exclude those students from the result. | |
*/ | |
with count_table as ( | |
select | |
h.hacker_id, | |
h.name, | |
count(*) challenge_count | |
from | |
challenges c |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[tool.poetry] | |
name = "{{cookiecutter.directory_name}}" | |
version = "0.1.0" | |
description = "" | |
authors = ["{{cookiecutter.author_name}}"] | |
[tool.poetry.dependencies] | |
python = "^3.8" | |
dvc = "^2.10.0" | |
hydra-core = "^1.1.1" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
person1 | person2 | |
---|---|---|
Alex | Oliver | |
Ben | Cathy | |
Ben | Oliver | |
Cathy | Oliver | |
Cathy | Olivia | |
Cathy | Alex | |
Michael | Oliver | |
Olivia | Michael |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[(datetime.date(2021, 12, 31), 'New year (Observed)'), | |
(datetime.date(2022, 1, 1), 'New year'), | |
(datetime.date(2022, 1, 17), 'Birthday of Martin Luther King, Jr.'), | |
(datetime.date(2022, 2, 21), "Washington's Birthday"), | |
(datetime.date(2022, 5, 30), 'Memorial Day'), | |
(datetime.date(2022, 7, 4), 'Independence Day'), | |
(datetime.date(2022, 9, 5), 'Labor Day'), | |
(datetime.date(2022, 10, 10), 'Columbus Day'), | |
(datetime.date(2022, 11, 11), 'Veterans Day'), | |
(datetime.date(2022, 11, 24), 'Thanksgiving Day'), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from datetime import date | |
from workalendar.usa import UnitedStates | |
# Get all holidays in the US | |
US_cal = UnitedStates() | |
US_cal.holidays(2022) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"basics": { | |
"name": "Khuyen Tran", | |
"label": "DevRel @ Prefect | Share 500+ daily tips on Python and data science", | |
"image": "", | |
"email": "khuyentran1476@gmail.com", | |
"phone": "6185146428", | |
"url": "https://github.com/khuyentran1401/", | |
"summary": "I'm the author of the book \"Efficient Python Tricks and Tools for Data Scientists\". I have written over 130 data science articles with over 10k followers on Medium. I have also posted over 400 tips on Python and data science on my website. \n\nMy current mission is to make open-source more accessible to the data science community. Reach out to me if you have or know any open-source libraries that are worth sharing. \n\nView my daily data science tips and blogs at https://mathdatasimplified.com.\nView my book at: https://khuyentran1401.github.io/Efficient_Python_tricks_and_tools_for_data_scientists", | |
"location": { |
NewerOlder