Text this: Neural networks for solving partial differential equations, a comprehensive review of recent methods and applications