Skip to content

Instantly share code, notes, and snippets.

View ryansmccoy's full-sized avatar
🦖
I may be slow to respond.

ryan ryansmccoy

🦖
I may be slow to respond.
View GitHub Profile
#Persistent
#SingleInstance, Force
#NoEnv
SetBatchLines, 1
SetBatchLines 15ms
Thread, NoTimers, true
;Menu, Tray, Icon, , , 1
Pause
#SingleInstance force
$RButton::
Send {RButton}
Return
@ryansmccoy
ryansmccoy / gist:9a175b27c9e7239b30ade6576bd0a262
Last active November 3, 2020 23:40
ryan_syntax2017-02-22T21-29-13 copy.icls
<scheme name="ryan_syntax2017-02-22T21-29-13 copy" version="142" parent_scheme="Darcula">
<option name="FONT_SCALE" value="1.0" />
<metaInfo>
<property name="created">2020-11-03T17:39:20</property>
<property name="ide">Python</property>
<property name="ideVersion">2020.2.3.0.0</property>
<property name="modified">2020-11-03T17:39:23</property>
<property name="originalScheme">ryan_syntax2017-02-22T21-29-13 copy</property>
</metaInfo>
<option name="LINE_SPACING" value="1.2" />
import pandas as pd
pd.set_option('display.float_format', lambda x: f'{x:.5f}')
pd.set_option('display.max_columns', 100)
pd.set_option('display.max_rows', 100)
pd.set_option('display.width', 600)
filename = r'data\WMT_US.csv'
import csv
from datetime import datetime
filename = r'data\WMT_US.csv'
records = []
with open(filename, 'r') as f:
rows = csv.reader(f)
@ryansmccoy
ryansmccoy / csv2parquet.py
Last active September 8, 2020 01:53
Converts CSV to Parquet
#!/usr/bin/env python
"""Converts CSV file to Parquet
This module converts a CSV file to a Parquet file
Example:
$ python csv2parquet.py --input-filepath example.csv --output-filepath example.parquet
@ryansmccoy
ryansmccoy / read_excel_xml.py
Last active October 26, 2019 05:44
Read in XLS file formatted as XML
from bs4 import BeautifulSoup
def read_excel_xml(filepath):
"""
Read in XLS file formatted as XML
:param filepath:
:return:
"""
@ryansmccoy
ryansmccoy / multiprocessing_queue.py
Created July 22, 2019 16:44
benchmarking python multiprocessing queue
import sys
import time, datetime
import numpy as np
import pandas as pd
pd.set_option("display.float_format", lambda x: f"{x:.5f}")
pd.set_option("display.max_columns", 100)
pd.set_option("display.max_rows", 100)
pd.set_option("display.width", 600)
import pandas as pd
from datetime import datetime
df_calendar = pd.read_html(r'https://finance.yahoo.com/calendar/earnings/')
df_all_est = []
for ticker in df_calendar[0]['Symbol'].tolist():
try:
@ryansmccoy
ryansmccoy / keybase.md
Created December 9, 2018 15:45
keybase.md

Keybase proof

I hereby claim:

  • I am ryansmccoy on github.
  • I am ryansmccoy (https://keybase.io/ryansmccoy) on keybase.
  • I have a public key ASCKJFvXQYTHZlTGI1es5Sr_DcESGx555Kbi_nTZmR7HSAo

To claim this, I am signing this object: