Process a Field

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, configures, and runs the operator
>>> from techminer2.database.operators import TransformOperator
>>> (
...     TransformOperator()
...     #
...     # FIELDS:
...     .with_field("author_keywords")
...     .with_other_field("author_keywords_copy")
...     #
...     # TRANSFORMATION:
...     .with_transformation_function(lambda x: x.str.lower())
...     #
...     # DATABASE:
...     .where_root_directory_is("examples/fintech/")
...     #
...     .run()
... )

>>> # Query the database to test the operation
>>> from techminer2.database.tools import Query
>>> (
...     Query()
...     .with_query_expression("SELECT author_keywords_copy FROM database LIMIT 10;")
...     .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()
... )
                                author_keywords_copy
0  elaboration_likelihood_model; fintech; k_pay; ...
1  actor_network_theory; chinese_telecom; fintech...
2  financial_inclusion; financial_scenarization; ...
3                 banking_innovations; fintech; risk
4  behavioural_economics; digital_technologies; f...
5            data_mining; fintech; privacy; security
6  content_analysis; digitalization; fintech; inn...
7  case_study; ecosystem_development; financial_i...
8  digitization; financial_services_industry; fin...
9  digital_finance; e_finance; fintech; future_re...

>>> # Deletes the field
>>> from techminer2.database.operators import DeleteOperator
>>> DeleteOperator(
...     field="author_keywords_copy",
...     root_directory="examples/fintech/",
... ).run()