khuyentran1401

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

khuyentran1401

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

khuyentran1401

{
  "vim.normalModeKeyBindings": [
        {
            "before": ["J"],
            "after": ["5", "j"]
        },
        {
            "before": ["K"],
            "after": ["5", "k"]
        } 

khuyentran1401

/*
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

khuyentran1401

/*
 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

khuyentran1401

[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"

khuyentran1401

khuyentran1401

[(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'),

khuyentran1401

from datetime import date 
from workalendar.usa import UnitedStates

# Get all holidays in the US

US_cal = UnitedStates()
US_cal.holidays(2022)

khuyentran1401

{
  "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": {