Count Terms per RecordΒΆ

Example

>>> import shutil
>>> shutil.copy("examples/fintech/database.csv.zip", "examples/fintech/data/processed/database.csv.zip")
'examples/fintech/data/processed/database.csv.zip'
>>> # Creates, configure, and run the operator
>>> from techminer2.database.operators import CountOperator
>>> (
...     CountOperator()
...     #
...     # FIELDS:
...     .with_field("authors")
...     .with_other_field("num_authors_test")
...     #
...     # DATABASE:
...     .where_root_directory_is("examples/fintech/")
...     #
...     .run()
... )
>>> # Query the database to test the operator
>>> from techminer2.database.tools import Query
>>> (
...     Query()
...     .with_query_expression("SELECT authors, num_authors_test FROM database LIMIT 5;")
...     .where_root_directory_is("examples/fintech/")
...     .where_database_is("main")
...     .where_record_years_range_is(None, None)
...     .where_record_citations_range_is(None, None)
...     .run()
... )
                                authors  num_authors_test
0  Kim Y.; Choi J.; Park Y.-J.; Yeon J.                 4
1                   Shim Y.; Shin D.-H.                 2
2                               Chen L.                 1
3              Romanova I.; Kudinska M.                 2
4                   Gabor D.; Brooks S.                 2
>>> # Deletes the field
>>> from techminer2.database.operators import DeleteOperator
>>> DeleteOperator(
...     field="num_authors_test",
...     root_directory="examples/fintech/",
... ).run()