def test_load_births(self):
births = load_births()
self.assertEqual(len(births), 408)
self.assertEqual(list(births.columns), ["date", "births"])
def test_execute_method_returning_none(self):
births = load_births()
result = SQLDF(locals()).execute(
"select a from births limit 10;") # col a not exists
self.assertEqual(result, None)
def test_execute_method_returning_none(self):
births = load_births()
result = SQLDF(locals()).execute(
"select a from births limit 10;") # col a not exists
self.assertEqual(result, None)
#pip install pysqldf
from pysqldf import SQLDF, load_meat, load_births
sqldf = SQLDF(globals())
meat = load_meat()
births = load_births()
print(sqldf.execute("SELECT * FROM meat LIMIT 10;").head())
