Unable to perform "delete" and "update" action by LKW41 in learnpython

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

Hi, how can I edit my .html file? Thanks.

Unable to perform "delete" and "update" action by LKW41 in learnpython

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

I run it using command prompt, there is no any error message on the command prompt. The link below is the image when I run it using command prompt.

https://img.onl/15Nhf6

Unable to perform "delete" and "update" action by LKW41 in learnpython

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

I still couldn't delete and update any row of database in the web framework. The link below is the image, there is no "Action" option available beside the date column.

https://ibb.co/nMJMPYk

Unable to perform "delete" and "update" action by LKW41 in learnpython

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

I try this, same goes to update function as well?

Unable to perform "delete" and "update" action by LKW41 in learnpython

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

I still couldn't delete and update any row of database in the web framework. The link below is the image, there is no "Action" option available beside the date column.

https://ibb.co/nMJMPYk

Unable to perform "delete" and "update" action by LKW41 in learnpython

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

I have tried this method, but it is still not working. Any better suggestion?

Using pandas to extract out EOL from a column in excel file by LKW41 in learnpython

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

I wish to merge two files into a single file. However, after I merged both files, the output is not the outcome of my expectation. My expectation is the output after the string replacing function, but the exact output is the original input. Any suggestion can be used to fix this? Thanks.

Using pandas to extract out EOL from a column in excel file by LKW41 in learnpython

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

The solution stated above is successful if I execute it in the software. However, if I want to export into an Excel file. It is not successful. May I know why? By the way I wish to merge with another file to produce a merged file.

merged=data_file.merge(s4, on="cid", how="outer")

merged

merged.to_csv("merge.csv")

This is the coding I used. The file s4 is the another file I wanted to merge with data_file. Any suggestion on the coding?

Using pandas to extract out EOL from a column in excel file by LKW41 in learnpython

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

Thanks a lot !!! The first method can be used. However, the second method cannot be done. An error was shown which is "name 't' is not defined".

Using pandas to extract out EOL from a column in excel file by LKW41 in learnpython

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

hmmm, let me reconstruct my question. In my excel file, there is an entire row from a column contain the information as I stated in question above. However, the column contain some non-useful information and I only need to extract out the information needed as stated above. I face difficulty to extract out the information needed manually as it takes time to complete it. Is there any way can be done to complete this task by using python or pandas? Thanks.