Files
quantconnect--lean/Common/Util/PythonUtil.cs
Colton Sellers b8033c496c Bug 4487 Get Fundamental for CSharp (#4703)
* Add unit tests

* Refactor Py and create C# function

* Update readme to include local

* Refactor solution; fix python cases

* Update tests

* Don't accept null selector for python; Create SelectedData class

* Fix Testing

* Pre review

* Fix tests for Travis

* Test fix V2

* Test fix V3

* Refactor quantbook and fix tests

* Sort list by date

* Move ConvertToSymbols to Python Util

* Address review

* Order dataframe columns by Security ID

* Address review V2

* header for PythonUtilTests
2020-09-16 18:06:01 -03:00

284 lines
12 KiB
C#

/*
* QUANTCONNECT.COM - Democratizing Finance, Empowering Individuals.
* Lean Algorithmic Trading Engine v2.0. Copyright 2014 QuantConnect Corporation.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
*/
using Python.Runtime;
using QuantConnect.Data.Fundamental;
using QuantConnect.Data.UniverseSelection;
using System;
using System.Collections.Generic;
using System.Linq;
namespace QuantConnect.Util
{
/// <summary>
/// Collection of utils for python objects processing
/// </summary>
public class PythonUtil
{
private static readonly Lazy<dynamic> lazyInspect = new Lazy<dynamic>(() => Py.Import("inspect"));
/// <summary>
/// Encapsulates a python method with a <see cref="System.Action{T1}"/>
/// </summary>
/// <typeparam name="T1">The input type</typeparam>
/// <param name="pyObject">The python method</param>
/// <returns>A <see cref="System.Action{T1}"/> that encapsulates the python method</returns>
public static Action<T1> ToAction<T1>(PyObject pyObject)
{
using (Py.GIL())
{
long count = 0;
if (!TryGetArgLength(pyObject, out count) || count != 1)
{
return null;
}
dynamic method = GetModule().GetAttr("to_action1");
return method(pyObject, typeof(T1)).AsManagedObject(typeof(Action<T1>));
}
}
/// <summary>
/// Encapsulates a python method with a <see cref="System.Action{T1, T2}"/>
/// </summary>
/// <typeparam name="T1">The first input type</typeparam>
/// <typeparam name="T2">The second input type type</typeparam>
/// <param name="pyObject">The python method</param>
/// <returns>A <see cref="System.Action{T1, T2}"/> that encapsulates the python method</returns>
public static Action<T1, T2> ToAction<T1, T2>(PyObject pyObject)
{
using (Py.GIL())
{
long count = 0;
if (!TryGetArgLength(pyObject, out count) || count != 2)
{
return null;
}
dynamic method = GetModule().GetAttr("to_action2");
return method(pyObject, typeof(T1), typeof(T2)).AsManagedObject(typeof(Action<T1, T2>));
}
}
/// <summary>
/// Encapsulates a python method with a <see cref="System.Func{T1, T2}"/>
/// </summary>
/// <typeparam name="T1">The data type</typeparam>
/// <typeparam name="T2">The output type</typeparam>
/// <param name="pyObject">The python method</param>
/// <returns>A <see cref="System.Func{T1, T2}"/> that encapsulates the python method</returns>
public static Func<T1, T2> ToFunc<T1, T2>(PyObject pyObject)
{
using (Py.GIL())
{
long count = 0;
if (!TryGetArgLength(pyObject, out count) || count != 1)
{
return null;
}
dynamic method = GetModule().GetAttr("to_func");
return method(pyObject, typeof(T1), typeof(T2)).AsManagedObject(typeof(Func<T1, T2>));
}
}
/// <summary>
/// Encapsulates a python method in coarse fundamental universe selector.
/// </summary>
/// <param name="pyObject">The python method</param>
/// <returns>A <see cref="Func{T, TResult}"/> (parameter is <see cref="IEnumerable{CoarseFundamental}"/>, return value is <see cref="IEnumerable{Symbol}"/>) that encapsulates the python method</returns>
public static Func<IEnumerable<CoarseFundamental>, IEnumerable<Symbol>> ToCoarseFundamentalSelector(PyObject pyObject)
{
var selector = ToFunc<IEnumerable<CoarseFundamental>, Symbol[]>(pyObject);
if (selector == null)
{
using (Py.GIL())
{
throw new ArgumentException($"{pyObject.Repr()} is not a valid coarse fundamental universe selector method.");
}
}
return selector;
}
/// <summary>
/// Encapsulates a python method in fine fundamental universe selector.
/// </summary>
/// <param name="pyObject">The python method</param>
/// <returns>A <see cref="Func{T, TResult}"/> (parameter is <see cref="IEnumerable{FineFundamental}"/>, return value is <see cref="IEnumerable{Symbol}"/>) that encapsulates the python method</returns>
public static Func<IEnumerable<FineFundamental>, IEnumerable<Symbol>> ToFineFundamentalSelector(PyObject pyObject)
{
var selector = ToFunc<IEnumerable<FineFundamental>, Symbol[]>(pyObject);
if (selector == null)
{
using (Py.GIL())
{
throw new ArgumentException($"{pyObject.Repr()} is not a valid fine fundamental universe selector method.");
}
}
return selector;
}
/// <summary>
/// Parsers <see cref="PythonException.StackTrace"/> into a readable message
/// </summary>
/// <param name="value">String with the stacktrace information</param>
/// <returns>String with relevant part of the stacktrace</returns>
public static string PythonExceptionStackParser(string value)
{
if (string.IsNullOrWhiteSpace(value))
{
return string.Empty;
}
// Get the directory where the user files are located
var baseScript = value.GetStringBetweenChars('\"', '\"');
var length = Math.Max(baseScript.LastIndexOf('/'), baseScript.LastIndexOf('\\'));
if (length < 0)
{
return string.Empty;
}
var directory = baseScript.Substring(0, 1 + length);
// Format the information in every line
var lines = value.Substring(1, value.Length - 1)
.Split(new[] { "\' File " }, StringSplitOptions.RemoveEmptyEntries)
.Where(x => x.Contains(directory))
.Where(x => x.Split(',').Length > 2)
.Select(x =>
{
var info = x.Replace(directory, string.Empty).Split(',');
var line = info[0].GetStringBetweenChars('\"', '\"');
line = $" in {line}:{info[1].Trim()}";
info = info[2].Split(new[] { "\\n" }, StringSplitOptions.RemoveEmptyEntries);
line = $" {info[0].Replace(" in ", " at ")}{line}";
// If we have the exact statement, add it to the error line
if (info.Length > 2) line += $" :: {info[1].Trim()}";
return line;
});
var errorLine = string.Join(Environment.NewLine, lines);
return string.IsNullOrWhiteSpace(errorLine)
? string.Empty
: $"{Environment.NewLine}{errorLine}{Environment.NewLine}";
}
/// <summary>
/// Try to get the length of arguments of a method
/// </summary>
/// <param name="pyObject">Object representing a method</param>
/// <param name="length">Lenght of arguments</param>
/// <returns>True if pyObject is a method</returns>
private static bool TryGetArgLength(PyObject pyObject, out long length)
{
using (Py.GIL())
{
var inspect = lazyInspect.Value;
if (inspect.isfunction(pyObject))
{
var args = inspect.getargspec(pyObject).args as PyObject;
var pyList = new PyList(args);
length = pyList.Length();
pyList.Dispose();
args.Dispose();
return true;
}
if (inspect.ismethod(pyObject))
{
var args = inspect.getargspec(pyObject).args as PyObject;
var pyList = new PyList(args);
length = pyList.Length() - 1;
pyList.Dispose();
args.Dispose();
return true;
}
}
length = 0;
return false;
}
/// <summary>
/// Creates a python module with utils methods
/// </summary>
/// <returns>PyObject with a python module</returns>
private static PyObject GetModule()
{
return PythonEngine.ModuleFromString("x",
"from clr import AddReference\n" +
"AddReference(\"System\")\n" +
"from System import Action, Func\n" +
"def to_action1(pyobject, t1):\n" +
" return Action[t1](pyobject)\n" +
"def to_action2(pyobject, t1, t2):\n" +
" return Action[t1, t2](pyobject)\n" +
"def to_func(pyobject, t1, t2):\n" +
" return Func[t1, t2](pyobject)");
}
/// <summary>
/// Convert Python input to a list of Symbols
/// </summary>
/// <param name="input">Object with the desired property</param>
/// <returns>List of Symbols</returns>
public static IEnumerable<Symbol> ConvertToSymbols(PyObject input)
{
List<Symbol> symbolsList;
Symbol symbol;
// Handle the possible types of conversions
if (PyList.IsListType(input))
{
List<string> symbolsStringList;
//Check if an entry in the list is a string type, if so then try and convert the whole list
if (PyString.IsStringType(input[0]) && input.TryConvert(out symbolsStringList))
{
symbolsList = new List<Symbol>();
foreach (var stringSymbol in symbolsStringList)
{
symbol = QuantConnect.Symbol.Create(stringSymbol, SecurityType.Equity, Market.USA);
symbolsList.Add(symbol);
}
}
//Try converting it to list of symbols, if it fails throw exception
else if (!input.TryConvert(out symbolsList))
{
throw new ArgumentException($"Cannot convert list {input.Repr()} to symbols");
}
}
else
{
//Check if its a single string, and try and convert it
string symbolString;
if (PyString.IsStringType(input) && input.TryConvert(out symbolString))
{
symbol = QuantConnect.Symbol.Create(symbolString, SecurityType.Equity, Market.USA);
symbolsList = new List<Symbol> { symbol };
}
else if (input.TryConvert(out symbol))
{
symbolsList = new List<Symbol> { symbol };
}
else
{
throw new ArgumentException($"Cannot convert object {input.Repr()} to symbol");
}
}
return symbolsList;
}
}
}