Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: Analyzing yearly expenses (CSV file) from debit card
Post: RE: Analyzing yearly expenses (CSV file) from debi...
Quote:It can do formatting too:
https://openpyxl.readthedocs.io/en/stable/styles.html
Quote:Openpyxl does charts too: https://openpyxl.readthedocs.i/oen/stabl...ction.html
I must say I haven't used ... |
|
Python_User |
Data Science |
4 |
2,589 |
Dec-14-2020, 06:29 PM |
|
|
Thread: Analyzing yearly expenses (CSV file) from debit card
Post: RE: Analyzing yearly expenses (CSV file) from debi...
(Dec-13-2020, 02:29 PM)palladium Wrote: Are you trying to build a pivot table? pandas has support for them, though I must admit I haven't use it before.
Formatting cells (e.g. changing fonts to bo... |
|
Python_User |
Data Science |
4 |
2,589 |
Dec-13-2020, 02:42 PM |
|
|
Thread: Analyzing yearly expenses (CSV file) from debit card
Post: Analyzing yearly expenses (CSV file) from debit ca...
Hello,
I am quite new with programming in Python and now I have started my (kind of) 'first' project in Python. I want to analyse my yearly expenses and I think pandas is the best way to give a clear... |
|
Python_User |
Data Science |
4 |
2,589 |
Dec-13-2020, 02:24 PM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
from tkinter.filedialog import askopenfilename
from pathlib import Path
import sys
import csv
def get_filename():
filename = Path(askopenfilename(filetypes=[("CSV files","*.csv")]))
return f... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-13-2020, 10:21 AM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
(Dec-07-2020, 10:17 PM)Larz60+ Wrote: Quote:What does this part of the code below? Could you provide some explanation behind the lines of code as comments?
for example, filename = Path('/media/stub... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-08-2020, 07:13 PM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
Quote:perhaps I can get to documenting the entire code.
I wrote it in 10 minutes, and haden't planned on documenting, I have my regular work to do, as well as answering so many questions (as a volunte... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-07-2020, 05:22 PM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
The delimiter isn't working in this code? When I change it to ':' I still see the comma's as delimiters...
crdr = csv.reader(fp, delimiter=':')
cwrtr = csv.writer(fout, delimiter=':') |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-06-2020, 02:30 PM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
As addition, why isn't root = Tk() used in this code?
In the video below at 03:45 the guy says this should be used always in Tkinter...?
Tkinter root |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-06-2020, 09:06 AM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
What does this part of the code below? Could you provide some explanation behind the lines of code as comments?
def read_csv_file(filename):
parts = list(filename.parts)
parts[-1] = f"{filena... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-06-2020, 08:56 AM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
Hey Larz60,
What is the function of path in filename = Path(askopenfilename(filetypes=[("CSV files","*.csv")]))?
And where does the askopenfilename function refers to? Because when I run the code, i... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-05-2020, 04:14 PM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
Thank you Larz60, I am going to study the code supported with the python books I have this weekend, I am quite busy with work at the moment. I will let you know if problems occurs. Thanks for offering... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-03-2020, 07:25 PM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
Whoo, this is some heavy code for me **biggrin** . To be honest, I am already lost after the first 11 lines of code. What should you advise studying code like this? I tried learning the book "Automate... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-01-2020, 06:08 PM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
I am sorry for the confusion, I think my description has not been clear.
I am seeking for a function which checks the current csv file on its filename. This filename should be remembered in the code ... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Dec-01-2020, 07:11 AM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
I don't know, that's the reason I try to find out on this forum.
Should this work in a 'for' loop? Is that what you mean? |
|
Python_User |
General Coding Help |
25 |
7,903 |
Nov-30-2020, 06:54 PM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
(Nov-29-2020, 04:07 PM)Larz60+ Wrote: replace in 'MODIFIED_NAME_OF_THE_ORIGIN_FILE.csv' with your file name, 'Book1_MODIFIED.csv' line 10
I prefer having a code which 'looks' to the file name and in... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Nov-30-2020, 08:12 AM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
Is there anyone who can help me with this query?
Thanks in advance. |
|
Python_User |
General Coding Help |
25 |
7,903 |
Nov-29-2020, 08:14 AM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: RE: How to rename a CSV file by adding MODIFIED in...
I am sorry for the late response. Here is what I got so far:
import os
from pathlib import Path
import pandas as pd
df = pd.read_csv('Book1.csv')
df["NEW COLUMN"] = ""
df.to_csv('MODIFIED_NAME_OF... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Nov-26-2020, 06:35 PM |
|
|
Thread: How to rename a CSV file by adding MODIFIED in the filename?
Post: How to rename a CSV file by adding MODIFIED in the...
Hello all,
I am working and editing a CSV file using python. In my python code I want to add the following:
I have a CSV file "Book1.csv" for example. After I have run my python code and modificatio... |
|
Python_User |
General Coding Help |
25 |
7,903 |
Nov-25-2020, 05:56 PM |
|
|
Thread: Open for Python project(s)
Post: RE: Open for Python project(s)
(Sep-09-2020, 05:51 PM)Naheed Wrote: well according to my personal experience, Stack overflow is the best among all.
however, it is also a great idea idea to create a community of people of your pr... |
|
Python_User |
General Coding Help |
8 |
3,198 |
Sep-10-2020, 07:45 PM |
|
|
Thread: Open for Python project(s)
Post: RE: Open for Python project(s)
Quote:Hi
Perhaps administrators of these forums can create a new category "Python Collaboration" and some appropriately named sub forums?
Having a Collaboration section would also help site users pe... |
|
Python_User |
General Coding Help |
8 |
3,198 |
Sep-06-2020, 06:04 PM |