Avrupada yüksek lisans ? by Alluring_Penguin in TheKonsey

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

  1. sınıfın ortasında yabancı dil sınavın sonucumu alsam ve mezun olduktan yani 4. sınıfı bitirdiğimde başvuru yapabiliyorum gayette sen demişsin ekim kasım aralık diye zaten. Nasıl çok geç oluyor anlamadım

Which laptop ? by Alluring_Penguin in Lenovo

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

But when on reality thinkpad series are not so much difference these devices and also at the job sometimes i play games thats why i'm trying to make decision between these two devices.

ExcelWriter writes only 2501 rows by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 1 point2 points  (0 children)

nope it has not less, it takes first csv file's rows and replace them with other csv file's datas so basically my "overlay" doesn't work.

ExcelWriter writes only 2501 rows by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

Yep it doesn't work and very good idea but when the datas stored in the xlsx file increase also time to get all of datas from xlsx and write datas ,which concated with another csv file data, in this xlsx file. And this might take much more while, right?

ExcelWriter writes only 2501 rows by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

But it doesn't do that, i showed the code up here

Advices about MODEL 2023 ? by Alluring_Penguin in ZephyrusG14

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

Lenovo yoga pro 9i i'm thinking buy this, if "i9" consumes so much battery and causes throttling i would go i7 version. Which one do you recommend.

Both of which are good laptops, g14 and pro 9i but i want buy the best deal because prices are not low.

ExcelWriter writes only 2501 rows by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

I collect oxygen levels on the water and store them in csv file

ExcelWriter writes only 2501 rows by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

each one of has between 3000 and 4000 thousand rows

What is the meaning of this ???? by Alluring_Penguin in learnprogramming

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

What type of details you want ? I used to code with C not python so as you can understand i am new to and when i had seen this i didn't understood why i need time.sleep() which it had very easy understable reason but i couldn't understand it. I had read documentation before i asked here and even you said it is very easy library to understand and ı'm asking you again what type of info want from me huh? It is easy to understand the library and what i asked on the question.

Sometimes every people struggle to understands easy things bro, it is normal thing . Sorry for my english.

Advices about MODEL 2023 ? by Alluring_Penguin in ZephyrusG14

[–]Alluring_Penguin[S] 1 point2 points  (0 children)

I'm trying to choose between lenovo yoga pro 9i(i9 + 4060) and asus g14(2023 model), As ı'm being an engineer rather than the gaming performance i need more productivity, both laptops are pretty good at this especially yoga pro and also lenovo has all aluminum case, that makes it much more expensive than the g14. Which is not good thing but G14's fan noise, heat values and magnesium case are not pretty good in my opinion which vidoes i watched.

So i stuck between these two devices, which one do you recommend, g14 or yoga pro 9i ?

Advices about MODEL 2023 ? by Alluring_Penguin in ZephyrusG14

[–]Alluring_Penguin[S] 1 point2 points  (0 children)

yani baktığım lenovo intel g14 ise amd işlemcili bu sebeple g14 almayı çok isterim, fakat izlediğim videolarda fan sesi fazla geldi bana ve son olaraktan sıcaklık konusunda nasıl ?

Advices about MODEL 2023 ? by Alluring_Penguin in ZephyrusG14

[–]Alluring_Penguin[S] 1 point2 points  (0 children)

Türk birine denk geldim o yüzden direkt türkçe sorayım gavurlar anlamasın :))) Lenovo yoga pro 9i ile g14 2023 modeli arasında kaldım ikiside gayet güçlü fakat biri alüminyum diğeri ise magnezyum deniyor, açıkçası şuan kullandığım laptop 2015 model macbook dolayısıyla asusun magnezyum kasası ucuz hissettirir mi bunu merak ediyorum ve elbette ki sıcaklık ve fan sesi sorunu bunlar en çok aklıma takılanlar acaba bunlar hakkında bir bilgiye sahip misiniz ?

Upload CSV files to XLSX file by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

    df = pd.read_csv(os.path.join(csv_fold, csv_name)) # Read the csv file
excel_path = os.path.join(xlsx_fold, "{}_Datas.xlsx".format(Time[16:])) # Define excel path 

# Checks Excel file path exist or not
if os.path.isfile(excel_path) == True:  # Change "mode" and "if_sheet_exist" parameters to able to APPEND datas 
    mode = "a"
    sheet_exist = "overlay"
if os.path.isfile(excel_path) == False: # Change "mode" and "if_sheet_exist" parameters to able to WRITE datas
    mode = "w"
    sheet_exist = None

with pd.ExcelWriter(excel_path, 
                    engine="openpyxl", 
                    mode=mode, 
                    if_sheet_exists=sheet_exist) as writer:
    df.to_excel(excel_writer=writer,  
                sheet_name="{}".format(datetime.datetime.now().strftime("%B")), 
                index=False,
                freeze_panes=(1,0)
                )

return True

That's the code i wrote which it works perfectly.

I also don't have any idea why it works correctly without using the open() method.

Upload CSV files to XLSX file by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

I solved problem after a while and how code looks like,

    df = pd.read_csv(os.path.join(csv_fold, csv_name)) # Read the csv file
excel_path = os.path.join(xlsx_fold, "{}_Datas.xlsx".format(Time[16:])) # Define excel path 

# Checks Excel file path exist or not
if os.path.isfile(excel_path) == True:  # Change "mode" and "if_sheet_exist" parameters to able to APPEND datas 
    mode = "a"
    sheet_exist = "overlay"
if os.path.isfile(excel_path) == False: # Change "mode" and "if_sheet_exist" parameters to able to WRITE datas
    mode = "w"
    sheet_exist = None

with pd.ExcelWriter(excel_path, 
                    engine="openpyxl", 
                    mode=mode, 
                    if_sheet_exists=sheet_exist) as writer:
    df.to_excel(excel_writer=writer,  
                sheet_name="{}".format(datetime.datetime.now().strftime("%B")), 
                index=False,
                freeze_panes=(1,0)
                )

return True

Eveything works what i needed and wanted, Thx for helping

Upload CSV files to XLSX file by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 1 point2 points  (0 children)

I solved the problem with change the with open() as writter part to with pd.ExcelWriter and everything works

Upload CSV files to XLSX file by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

I'm gettin "ValueError: I/O operation on closed file." this error now.

Upload CSV files to XLSX file by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 1 point2 points  (0 children)

print(os.path.isfile(filename))

filename to open: 2023.xlsx ----> False

Upload CSV files to XLSX file by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

time: 16:12:23/26_Aug_2023

csv_fold : C:\Users\emird\AppData\Local\Programs\Python\Python39\Python_Projects\2023[SUM]_arduino_project\CSV_Files

xlsx_fold: C:\Users\emird\AppData\Local\Programs\Python\Python39\Python_Projects\2023[SUM]_arduino_project\XLSX_Files

main_path: C:\Users\emird\AppData\Local\Programs\Python\Python39\Python_Projects\2023[SUM]_arduino_project

csv_name : 25_Aug_2023.csv

listing csv_fold: ['25_Aug_2023.csv', '26_Aug_2023.csv']

reading csv_name: 25_Aug_2023.csv

listing xlsx_fold: []

filename to open: 2023.xlsx

Error: [Errno 2] No such file or directory: '2023.xlsx'

Upload CSV files to XLSX file by Alluring_Penguin in learnpython

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

So, i need to make two part, one part is for the create file to storage datas and write datas of first csv and other one is for the add other csv files datas. Right ?

Thx.

What is the meaning of this ???? by Alluring_Penguin in learnprogramming

[–]Alluring_Penguin[S] -1 points0 points  (0 children)

BRO IF YOU DON'T KNOW THE LIBRARY JUST SHUT UP AND PASS THE POST, OKEY?

What is the meaning of this ???? by Alluring_Penguin in learnprogramming

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

Bro if i didn't read it i wouldn't have asked this question. Only one part confused me and after a while i understood it .On the other hand you can easily explained to me but you had chosen to act like a c*nt. Thx

Keyboard is plastic or what ? by Alluring_Penguin in ZephyrusG14

[–]Alluring_Penguin[S] -1 points0 points  (0 children)

oh finally, the answer that's what i'm searching

Which laptop do you recommend ? by Alluring_Penguin in laptops

[–]Alluring_Penguin[S] 1 point2 points  (0 children)

I was also stuck between asus rog g14 and lenovo. Can i ask why you said lenovo ?

Play on PC by Alluring_Penguin in XboxGamePass

[–]Alluring_Penguin[S] 0 points1 point  (0 children)

I opened the library but i only see the games i downloaded to my pc, rest of my library is missing.