adxpandas

v0.2.3 suspicious
5.0
Medium Risk

Execute Kusto Query Language (KQL) queries over pandas DataFrames

🤖 AI Analysis

Final verdict: SUSPICIOUS

The package has a moderate risk score due to potential obfuscation techniques and lack of community engagement, raising concerns about its legitimacy and safety.

  • High obfuscation risk
  • Low metadata quality
Per-check LLM notes
  • Network: No network calls detected, which is normal unless the package requires network interaction for its functionality.
  • Shell: No shell execution patterns detected, indicating low risk of command injection or similar attacks.
  • Obfuscation: The use of base64 encoding for strings can be indicative of obfuscation to hide code logic or data, potentially malicious.
  • Credentials: No direct credential harvesting patterns detected, but the presence of obfuscation could indicate an attempt to conceal such activities.
  • Metadata: The repository is new, lacks community engagement, and the maintainer shows low effort in package management.

🔬 Heuristic Checks

✓ Outbound Network Calls

No suspicious network call patterns found

⚠ Code Obfuscation score 2.0

Found 1 obfuscation pattern(s)

  • urn None if text is None else base64.b64decode(text.encode("ascii")).decode("utf-8") def kql_replace_s
✓ Shell / Subprocess Execution

No shell execution patterns detected

✓ Credential Harvesting

No credential harvesting patterns detected

✓ Typosquatting

No typosquatting candidates detected

✓ Registered Email Domain

No author email provided

✓ Suspicious Page Links

All external links appear legitimate

⚠ Git Repository History score 5.0

Git history flags: Repository created very recently: 5 day(s) ago (2026-06-01T10:12:46Z)

  • Repository created very recently: 5 day(s) ago (2026-06-01T10:12:46Z)
  • Repository has zero stars and zero forks
⚠ Maintainer History score 6.0

3 maintainer concern(s) found

  • Author name is missing or very short
  • Author "" appears to have only 1 package on PyPI (new or inactive account)
  • Package has no PyPI classifiers (low effort / metadata quality)
✓ Known CVE Vulnerabilities

No known vulnerabilities found in OSV database.

💡 AI App Starter Prompt

Use this prompt to build a project with adxpandas 
Create a data analysis tool using Python that leverages the 'adxpandas' package to execute Kusto Query Language (KQL) queries on pandas DataFrames. This tool will serve as a bridge between the powerful querying capabilities of KQL and the ease of use provided by pandas, making it easier for users to analyze large datasets stored in pandas DataFrames.

Step 1: Setup your environment
- Install Python and necessary libraries including pandas and adxpandas.
- Ensure you have a sample dataset suitable for analysis, such as financial records, web logs, or sensor data.

Step 2: Design the User Interface
- Develop a simple command-line interface (CLI) where users can input their KQL queries.
- Implement basic error handling for invalid inputs or query errors.

Step 3: Integrate adxpandas
- Use adxpandas to convert the user's input KQL queries into operations that can be executed on pandas DataFrames.
- Execute these operations on the provided dataset and display the results back to the user.

Step 4: Enhance Functionality
- Add support for loading different types of datasets (CSV, Excel, SQL databases).
- Include functionality for saving query results to files or exporting them to other formats.
- Provide examples of common KQL queries that users can run out-of-the-box.

Step 5: Testing and Documentation
- Test the tool with various datasets and KQL queries to ensure reliability and accuracy.
- Document the setup process, usage instructions, and a guide on how to write effective KQL queries for pandas DataFrames.

By following these steps, you'll create a versatile data analysis tool that simplifies complex data querying tasks, making it accessible to both beginners and experienced data analysts.

💬 Discussion Feed

Leave a comment

No discussion yet. Be the first to share your thoughts!