Andrew Kittredge andrewkittredge
andrewkittredge
/ JoinWithTableExtensions.cs
Last active
November 29, 2023 21:18
Join entities with EntityFramework table
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
| #nullable enable | |
| using System; | |
| using System.Collections.Generic; | |
| using System.Diagnostics; | |
| using System.Linq; | |
| using System.Linq.Expressions; | |
| using BlazarTech.QueryableValues; | |
| using LinqKit; | |
| using Microsoft.EntityFrameworkCore; |
andrewkittredge
/ gist:dd926bd75cea90d03cafb53b54a3256a
Created
May 4, 2023 16:14
compare standardized dataframes
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
| a.merge(b, how="outer", indicator=True, left_index=True, right_index=True) |
andrewkittredge
/ load_calcbench_standardized_file.py
Last active
January 26, 2023 16:56
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
| pd.read_csv( | |
| "djia_sample.csv", | |
| parse_dates=["period_start", "period_end", "date_reported", "date_modified"], | |
| dtype={ | |
| "ticker": "string", | |
| "metric": "string", | |
| "CIK": "string", | |
| "filing_type": "string", | |
| "trace_url": "string", | |
| "filing_accession_number": "string", |