Hi Team,
Any update?
Search found 6 matches
- Fri Nov 20, 2020 10:22 am
- Forum: General Discussion
- Topic: How to load SQL data into MongoDB using python script
- Replies: 3
- Views: 19752
- Tue Nov 03, 2020 6:33 am
- Forum: General Discussion
- Topic: How to load SQL data into MongoDB using python script
- Replies: 3
- Views: 19752
How to load SQL data into MongoDB using python script
Hi Team,
Please help on bellow requirement.
Need to load data from SQL DB to Mongo DB using python script. Please help on same
Please help on bellow requirement.
Need to load data from SQL DB to Mongo DB using python script. Please help on same
- Tue Nov 03, 2020 6:30 am
- Forum: General Discussion
- Topic: SQL results to MS Teams using Python in table format
- Replies: 7
- Views: 20079
Re: SQL results to MS Teams using Python in table format
Thank you all. Issue was resolved
- Fri Sep 25, 2020 2:02 pm
- Forum: General Discussion
- Topic: SQL results to MS Teams using Python in table format
- Replies: 7
- Views: 20079
Re: SQL results to MS Teams using Python in table format
I think I like this formatting a bit better, and iterating over lists is more efficient. df = pd.read_sql(sql_query, conn) results = str(df).split(' ') columns = ['Status', 'Enum', 'Booking Status'] database_table_output = [] for i in range...
- Fri Sep 25, 2020 2:01 pm
- Forum: General Discussion
- Topic: SQL results to MS Teams using Python in table format
- Replies: 7
- Views: 20079
Re: SQL results to MS Teams using Python in table format
There's no "table" in Python. In generic terms, I think you'd want an associative array. Python supports dictionaries, which is a collection of key-value pairs. Keys and values can be of any data type I believe. There may be a more efficient or pythonic way to do this, but implement first...
- Fri Sep 25, 2020 7:38 am
- Forum: General Discussion
- Topic: SQL results to MS Teams using Python in table format
- Replies: 7
- Views: 20079
SQL results to MS Teams using Python in table format
Hi Team, Have wrote a small python script to send results to MS teams , when am try to sending it coming as string format. My Code: import pymsteams import pandas as pd import numpy as np import pyodbc from tabulate import tabulate server = ‘ServerName’ database = ‘DBName’ username = ‘username’ pass...