Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: How to select NULL and blank values from MySQL table into csv
Post: RE: How to select NULL and blank values from MySQL...
This works great but I was trying to avoid row level operations as the data could be huge. But I am evaluating your suggestion to see if it'll be feasible for my use case. Thank you again. |
|
python300 |
General Coding Help |
9 |
2,456 |
Dec-27-2022, 09:23 PM |
|
|
Thread: How to select NULL and blank values from MySQL table into csv
Post: RE: How to select NULL and blank values from MySQL...
(Dec-27-2022, 07:09 PM)deanhystad Wrote: Looks like you'll have to write the file yourself.
import pandas as pd
odd_stuff = pd.DataFrame([[1, '1', 'one', None, ''], [2, '2', '', None, None]])
def ... |
|
python300 |
General Coding Help |
9 |
2,456 |
Dec-27-2022, 07:51 PM |
|
|
Thread: How to select NULL and blank values from MySQL table into csv
Post: RE: How to select NULL and blank values from MySQL...
(Dec-20-2022, 05:12 AM)deanhystad Wrote: NaN will just be a string. Whatever usesthe generated csv file will have to know that the string "NaN" means NaN. What you want to write to the csv file in... |
|
python300 |
General Coding Help |
9 |
2,456 |
Dec-27-2022, 04:02 PM |
|
|
Thread: How to select NULL and blank values from MySQL table into csv
Post: RE: How to select NULL and blank values from MySQL...
(Dec-19-2022, 07:19 PM)deanhystad Wrote: Wrap code in python tags to save formatting
Python csv.writer will write null as a blank string. Actually, it writes None as a blank string. Database null... |
|
python300 |
General Coding Help |
9 |
2,456 |
Dec-19-2022, 09:16 PM |
|
|
Thread: How to select NULL and blank values from MySQL table into csv
Post: How to select NULL and blank values from MySQL tab...
Hi all,
I am trying to select specific columns from a MySQL table into csv.
This table can have NULL or blank values and I want to differentiate between two when I extract.
Right now what's happenin... |
|
python300 |
General Coding Help |
9 |
2,456 |
Dec-19-2022, 07:05 PM |
|
|
Thread: Trying to find the fastest way to bulk extract from oracle
Post: RE: Trying to find the fastest way to bulk extract...
(Aug-30-2022, 11:49 AM)Larz60+ Wrote: I have used Pandas https://pandas.pydata.org/ with impressive results
specifically:for database read - https://pandas.pydata.org/docs/reference...d_sql.html
... |
|
python300 |
News and Discussions |
2 |
1,435 |
Sep-09-2022, 09:23 PM |
|
|
Thread: Trying to find the fastest way to bulk extract from oracle
Post: Trying to find the fastest way to bulk extract fro...
Hi all,
We are on RHEL 8, Oracle DB 12+ and Python 3.9
I am trying to find the fastest way to extract large data from Oracle DB to local Linux file system in form of flat file (csv, txt, etc)
Data we... |
|
python300 |
News and Discussions |
2 |
1,435 |
Aug-30-2022, 06:07 AM |
|
|
Thread: How to move a class to a custom module?
Post: RE: How to move a class to a custom module?
Thank you @deanhystad for your helpful reply. Following your suggestion I was able to figure out how I could do this.
Contents of module log_format.py
import logging
import datetime as dt
... |
|
python300 |
General Coding Help |
4 |
1,569 |
Mar-08-2022, 09:19 PM |
|
|
Thread: How to move a class to a custom module?
Post: RE: How to move a class to a custom module?
(Feb-28-2022, 04:42 PM)deanhystad Wrote: I am confused. In our test you used the global variable "i" and you incremented it like htis:
i += 1; logger.info("I am INFO 0")In log_format.py you changed... |
|
python300 |
General Coding Help |
4 |
1,569 |
Feb-28-2022, 05:20 PM |
|
|
Thread: How to move a class to a custom module?
Post: How to move a class to a custom module?
I am using Python 3.6.0 :: Continuum Analytics, Inc. on Linux.
I have ContextFilter Class in my python script which I am using to have a counter variable in log formatter. It works as expected and pri... |
|
python300 |
General Coding Help |
4 |
1,569 |
Feb-28-2022, 03:47 PM |
|
|
Thread: Is there any keyboard shortcut to run code from Visual Studio Code?
Post: RE: Is there any keyboard shortcut to run code fro...
Finally I got answer to my second question (which I wanted to post as a new question) from SO.
Answer:
You can provide input by telling code runner to use the terminal.
To do this, there is a settin... |
|
python300 |
Bar |
3 |
61,398 |
Aug-07-2018, 09:12 PM |
|
|
Thread: Is there any keyboard shortcut to run code from Visual Studio Code?
Post: How to setup Code Runner in Visual Studio Code for...
I have installed Visual Studio Code and added extensions - Python, Code Runner.
With Code Runner, now I can see the Run Code symbol (triangle) and on highlighting it, I see the shortcut Ctrl + Alt + N... |
|
python300 |
Bar |
3 |
61,398 |
Jun-04-2018, 09:39 PM |
|
|
Thread: Is there any keyboard shortcut to run code from Visual Studio Code?
Post: Is there any keyboard shortcut to run code from Vi...
I know you can right click in the editor and select Run Python File in Terminal.
Or I can right click the name of the python file from left panel and select Run Python File in Terminal.
But what i am... |
|
python300 |
Bar |
3 |
61,398 |
Jun-04-2018, 07:33 PM |
|
|
Thread: Need some inputs on IDE comparison on Windows 7: PyCharm (CE) vs Code
Post: RE: Need some inputs on IDE comparison on Windows ...
|
python300 |
News and Discussions |
7 |
4,655 |
May-30-2018, 10:42 PM |
|
|
Thread: Need some inputs on IDE comparison on Windows 7: PyCharm (CE) vs Code
Post: RE: Need some inputs on IDE comparison on Windows ...
Thank you for your response wavic.
I would love to know the other perspective.
Can you please share benefits that you see with PyCharm over VS Code?
I am yet to board the bus so it could still be bene... |
|
python300 |
News and Discussions |
7 |
4,655 |
May-30-2018, 08:50 PM |
|
|
Thread: Need some inputs on IDE comparison on Windows 7: PyCharm (CE) vs Code
Post: RE: Need some inputs on IDE comparison on Windows ...
Thank you for your response buran and snippsat.
I am going with VS Code. |
|
python300 |
News and Discussions |
7 |
4,655 |
May-30-2018, 06:56 PM |
|
|
Thread: Need some inputs on IDE comparison on Windows 7: PyCharm (CE) vs Code
Post: Need some inputs on IDE comparison on Windows 7: P...
Hi all,
I want to decide on which IDE to use on my Windows 7 machine for Python 3.6
I know until recently, PyCharm would have been the best option but in my case I want to use PyCharm Community Editi... |
|
python300 |
News and Discussions |
7 |
4,655 |
May-30-2018, 03:40 PM |
|
|
Thread: How can I automate manual data validation using Python?
Post: How can I automate manual data validation using Py...
Here is what I do manually as of now:
I take raw data from source DB tables and do manual calculations on it using excel if needed. These manual calculations are on same lines of business logic. Final... |
|
python300 |
Data Science |
1 |
4,515 |
Jun-21-2017, 09:21 PM |
|
|
Thread: Issue in launching spyder that was installed using pip install on Python 3.6.1
Post: RE: Issue in launching spyder that was installed u...
Thank you so much snippsat. After I installed PyQt5 and upgraded spyder, it woked and I can launch spyder now. I had followed the post pythonhosted but while installing PyQt5 from cmd.exe got the ency... |
|
python300 |
General Coding Help |
6 |
11,066 |
Jun-02-2017, 10:44 PM |
|
|
Thread: Issue in launching spyder that was installed using pip install on Python 3.6.1
Post: RE: Issue in launching spyder that was installed u...
Oh! I didn't install Anaconda. Maybe that's where it's different for me. I installed Python and then Spyder using pip install. |
|
python300 |
General Coding Help |
6 |
11,066 |
Jun-02-2017, 09:13 PM |