User Tools

Site Tools




  • - similar to a left-join except that we match on nearest key rather than equal keys. It is useful for “projecting” low frequency data onto high frequency. For example, a company might release earnings only 4 times a year. But using this function, you can get the “latest” earnings as of a given date.

search tags | python matching dataframes with different frequency


Yes. The emini futures is a “1256 contract”. If a contract is a “1256 contract” then it is treated as sold for its fair market value on the last business day of the year for tax purposes. So you have to pay capital gains tax on the emini futures regardless of whether the gains (or losses) are realized or unrealized.




  • To compare two files or directories in pycharm, select the two files and press Control+d




  • Texas is nicknamed the “Lone Star State” for its former status as an independent republic, and as a reminder of the state's struggle for independence from Mexico. The “Lone Star” can be found on the Texas state flag and on the Texas state seal.




  • In 2000, the United States Food and Drug Administration (FDA) established an online registry for the details of clinical trials. The FDA required that scientists who were studying therapies for serious diseases needed to provide some details of their study designs and the outcomes that they planned to investigate. This requirement reduced the bias towards positive findings in published research. We see evidence of this in the chart, showing clinical trials funded by the National Heart, Lung and Blood Institute (NHLBI), which adopted this requirement. Before 2000 – when pre-registration of studies was not required – most candidate drugs to treat or prevent cardiovascular disease showed large benefits. But most trials published after 2000 showed no benefit.


til_2022.txt · Last modified: 2022/12/11 11:28 by raju