Python Forum
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

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020