Merge Fields¶

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 merger
>>> from techminer2.database.operators import MergeOperator
>>> merger = (
...     MergeOperator()
...     #
...     # FIELDS:
...     .with_field(["author_keywords", "index_keywords"])
...     .with_other_field("merged_keywords")
...     #
...     # DATABASE:
...     .where_root_directory_is("examples/fintech/")
... )
>>> merger.run()

>>> # Query the database to test the merger
>>> from techminer2.database.tools import Query
>>> query = (
...     Query()
...     .with_query_expression("SELECT merged_keywords 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)
... )
>>> df = query.run()
>>> df
                                     merged_keywords
0  ELABORATION_LIKELIHOOD_MODEL; FINTECH; K_PAY; ...
1  ACTOR_NETWORK_THEORY; CHINESE_TELECOM; CONVERG...
2  FINANCIAL_INCLUSION; FINANCIAL_SCENARIZATION; ...
3                 BANKING_INNOVATIONS; FINTECH; RISK
4  BEHAVIOURAL_ECONOMICS; DIGITAL_TECHNOLOGIES; E...
5  DATA_MINING; DATA_PRIVACY; FINANCE; FINANCIAL_...
6  CONCEPTUAL_FRAMEWORKS; CONTENT_ANALYSIS; DIGIT...
7  CASE_STUDY; COMMERCE; DIGITAL_TECHNOLOGIES; EC...
8  DIGITIZATION; FINANCIAL_SERVICES_INDUSTRY; FIN...
9  DIGITAL_FINANCE; E_FINANCE; FINTECH; FUTURE_RE...

>>> # Deletes the fields
>>> from techminer2.database.operators import DeleteOperator
>>> field_deleter = (
...     DeleteOperator()
...     .with_field("merged_keywords")
...     .where_root_directory_is("examples/fintech/")
... )
>>> field_deleter.run()