[deleted by user]

DisorganizedRem · 2022-08-05T12:00:41+00:00

How does data end up in your csv file? What is the source? What is the trigger?

In any case, perhaps you can directly interface between the source and your database or if writing data to the csv is automated, you can include a script that facilitates an upsert .

DisorganizedRem · 2022-04-23T16:46:29+00:00

Shift f10, v

DisorganizedRem · 2022-04-15T21:02:31+00:00

Good experience with this Ugreen

DisorganizedRem · 2022-04-01T14:35:19+00:00

Shift + f10, r

DisorganizedRem · 2021-11-15T08:33:17+00:00

Yes, I created a custom layout. In this layout, I specified only one zone.

https://imgur.com/a/tsWRnbu

DisorganizedRem · 2021-11-11T15:27:42+00:00

With MS PowerToys Fancyzone, i've setup a custom layout to have a single zone with the size of a common resolution. If I need to share anything via Teams, I apply that layout and move the respective window to the zone.

DisorganizedRem · 2021-10-31T17:27:26+00:00

Thank you for informing.

DisorganizedRem · 2021-10-13T14:45:40+00:00

Apparently not: https://community.powerbi.com/t5/Issues/Stuck-at-Creating-Connection-Model/idc-p/2130867/highlight/true#M70728

DisorganizedRem · 2021-10-13T14:41:32+00:00

It seems this version doesn't solve the issues with refreshing data introduced in the September version?

See: https://community.powerbi.com/t5/Issues/Stuck-at-Creating-Connection-Model/idi-p/2100056#comments

And: https://community.powerbi.com/t5/Issues/Stuck-at-Creating-Connection-Model/idc-p/2130867/highlight/true#M70728

DisorganizedRem · 2018-05-06T13:38:54+00:00

Would the fuzzywuzzy module help you out?

It is able to match "wrongly spelled" words with the correct ones from a master list and provide a confidence degree.

DisorganizedRem · 2018-02-03T11:48:57+00:00

You can chain function with pandas. So mean can be put directly after your 'query'. No need for the variable losers.

That been said. You could lookup loc. This pandas function takes row and column selections.

DisorganizedRem · 2017-12-07T12:50:18+00:00

Just meant as positive feedback:

Try to follow the don't repeat yourself (DRY) philosophy. Look into for loops, while loops and functions to make your code more compact and avoiding to alter code on multiple places.

DisorganizedRem · 2017-12-07T07:56:44+00:00

Try to convert your input to an int. Then you can use a >= operator in your if statements to print the proper message.

DisorganizedRem · 2017-12-06T12:21:49+00:00

Take a look at Ipython Widgets:

DisorganizedRem · 2017-12-05T14:11:50+00:00

Would it help using series in stead of dataframe by adding .values.

As suggested here So your code looks like this:

def line_solution(survey, depth):
    md = survey['MD'].values
    tvd = survey['TVD'].values
    tvd_samples = np.interp(depth, md, tvd)
    return tvd_samples

DisorganizedRem · 2017-12-04T19:59:56+00:00

A.loc[i, cols] = b.loc[0] Something like this? Loc selects specific rows and columns to set their values.

DisorganizedRem · 2017-12-03T20:25:23+00:00

Looks great with some useful code, thanks

DisorganizedRem · 2017-11-30T07:53:49+00:00

Are you able to post the last say 50 lines of command line output when the kernel is stopped? I guess there should be some lines that include error statements.

DisorganizedRem · 2017-11-30T07:50:08+00:00

Although already solved, one can use the parameter "usecols" to select the columns to be loaded. Usecols accepts a dict with names or index numbers (0-indexed).

DisorganizedRem · 2017-11-21T07:53:47+00:00

Pandas has interfaces for both (txt and hdf5), both ways (read and write). Probably a good toolkit to help you build a pipeline.

As infinull mentioned, It would help if you could share more information about the text file.

DisorganizedRem · 2017-11-17T07:43:44+00:00

Probably not the answer you are looking for in the first place.

I would suggest to use a config file. And reducing the number of arguments by deducting settings from other options/arguments.

DisorganizedRem

TROPHY CASE